Access Count Function

Last updated: August 26, 2026.

The Count aggregate returns the number of records or non-Null values in a query group.

Syntax

Count(expression)

Argument	Description
`expression`	Field or expression to count
`use * to count every selected record`	undefined

SELECT Count(*) AS RecordCount
FROM Orders;

SELECT Count(ShippedDate) AS ShippedDateCount
FROM Orders;

Count(*) includes records containing Null fields. Count(field) ignores records where that field is Null.

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