Last updated: August 26, 2026.
The First aggregate returns a value from the first record encountered by the query engine.
Syntax
First(expression)| Argument | Description |
|---|---|
expression | Field or expression from which to return a value |
Examples
SELECT CustomerID, First(OrderDate) AS EncounteredDate
FROM Orders
GROUP BY CustomerID;First does not mean earliest unless the input record order is guaranteed, and aggregate queries should not rely on that ordering. Use Min for the earliest value or a deterministic top-one query with ORDER BY.
See Microsoft’s Access function reference for related expression functions.
