Return the maximum value from the result set of a query. (SQL).
Syntax Max (expression) Key expression A field or formula that evaluates to a numeric expression.
Use the Max function in the access query builder by clicking the Totals toolbar button:
The Max function is used in conjunction with the Group By clause.
Select Max(price) from T_Sales Group By Supplier;
“Winning takes talent; to repeat takes character.” ~ John Wooden
DMax - Return the maximum value from a set of records.
Avg (SQL) - Average
Count (SQL) - Count records
Min (SQL) - Return the minimum value from a query.
Partition (SQL) - Locate a number within a range.
Sum (SQL) - Add up the values in a query result set.