Access Max Function

Last updated: August 26, 2026.

The Max aggregate returns the largest non-Null value in a query group.

Syntax

Max(expression)

Argument	Description
`expression`	Field or calculated expression whose largest value is required

SELECT Max(OrderTotal) AS LargestOrder
FROM Orders;

SELECT CustomerID, Max(OrderDate) AS LatestOrder
FROM Orders
GROUP BY CustomerID;

Max ignores Null values. Use a WHERE clause when only a particular date range or status should participate in the result.

See Microsoft’s Access function reference for related expression functions.