select max value from a table in ms access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • milinkumar
    New Member
    • Aug 2006
    • 3

    select max value from a table in ms access

    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.
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    "SELECT MAX([ApplicationID]) FROM tablename;"

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

    Originally posted by milinkumar
    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.

    Comment

    Working...