Last updated: August 26, 2026.
The Sum aggregate adds the non-Null numeric values in a query group.
Syntax
Sum(expression)| Argument | Description |
|---|---|
expression | Numeric field or calculated expression to total |
Examples
SELECT Sum(OrderTotal) AS Revenue
FROM Orders;
SELECT CustomerID, Sum(OrderTotal) AS Revenue
FROM Orders
GROUP BY CustomerID;Sum ignores Null values. Use Nz around the final aggregate when an empty result set should display zero.
See Microsoft’s Access function reference for related expression functions.
Moving an Access application to the web? See how PHPRunner can replace Access forms, queries, and reports.
