By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,599 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

select max value from a table in ms access

P: 3
i want to retraive the max ApplicationID from a table in ms access database.
But iam not getting the maximum ApplicationID. can any body tell me how to write the syntax for getting max value in ms access.
Aug 23 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
"SELECT MAX([ApplicationID]) FROM tablename;"

This should retrieve the max ApplicationID. It depend on where and how you're using it.

i want to retraive the max ApplicationID from a table in ms access database.
But iam not getting the maximum ApplicationID. can any body tell me how to write the syntax for getting max value in ms access.
Aug 23 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.