In MS Access, how do you find the highest value?

Answer by  cucuwito (34)

Go to the Query part of the access wizard and write an sql statement as follows select MAX(FieldName)as highestvalue from TABLE. this will return highest value as highestvalue once it has been executed.

Answer by  StandardDad (38)

Create a new query and edit the SQL in it as follows: select MAX(FIELD_NAME)as Highest_Field_Value from TABLE. Substitute the "FIELD_NAME" and "TABLE" into the SQL as required.

Answer by  gigo (1706)

You can easily use an SQL Statement to do that. Type SELECT fieldname FROM tablename ORDER BY fieldname DESC. You can run this statement in the SQL Editor or you can execute it with VBA. The execute function will return a recordset. You have to read out the first element of this recordset to get the highest value.

Answer by  gigo (1706)

To find the highest value in MS Access, you can use classical SQL. Just enter in the SQL form your SELECT query and use the additional keyword ORDER BY [columnname].

Answer by  gigo (1706)

Just use SQL. Go to the SQL editor and enter a query like SELECT value FROM valuetable WHERE value = ... order by value desc. Now you have the highest value at the top of the list. If you use additionally limit 1 at the end the query returns exactly one hit.