Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the number of records in a query or table.
Important
Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.
Syntax
Count (Expression)
The Count function contains the following argument.
| Argument name | Description |
|---|---|
| Expression |
A string expression identifying the field that contains the data you want to count or an expression that performs a calculation using the data in the field. Operands in Expression can include the name of a table field or function (which can be either intrinsic or user-defined but not other SQL aggregate functions). You can count any kind of data, including text. |
Remarks
You can use Count to count the number of records in an underlying query. For example, you could use Count to count the number of orders shipped to a particular country or region.
Count (*) returns the number of items in a group. This includes NULL values and duplicates.