Access Min Function

Last updated: August 26, 2026.

The Min aggregate returns the smallest non-Null value in a query group.

Syntax

Min(expression)

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

SELECT Min(UnitPrice) AS LowestPrice
FROM Products;

SELECT CustomerID, Min(OrderDate) AS FirstOrder
FROM Orders
GROUP BY CustomerID;

Min ignores Null values. It works with numbers, dates, and sortable text values.

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