Last updated: August 26, 2026.
The Last aggregate returns a value from the last record encountered by the query engine.
Syntax
Last(expression)| Argument | Description |
|---|---|
expression | Field or expression from which to return a value |
Examples
SELECT CustomerID, Last(OrderDate) AS EncounteredDate
FROM Orders
GROUP BY CustomerID;Last does not reliably mean latest. Use Max for the latest date or a deterministic query ordered by the required field.
See Microsoft’s Access function reference for related expression functions.
