Max

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.

Example

Select Max(price) 
from T_Sales 
Group By Supplier;

“Winning takes talent; to repeat takes character.” ~ John Wooden

Related:

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.