Last updated: August 26, 2026.
The Avg aggregate calculates the arithmetic mean of the non-Null values in a query group.
Syntax
Avg(expression)| Argument | Description |
|---|---|
expression | Numeric field or expression to average |
Examples
SELECT Avg(UnitPrice) AS AveragePrice
FROM Products;
SELECT CategoryID, Avg(UnitPrice) AS AveragePrice
FROM Products
GROUP BY CategoryID;Avg ignores Null values but includes zero. Filter rows explicitly when zero or a particular status should not contribute to the result.
See Microsoft’s Access function reference for related expression functions.
