MS Access Count() Function
Example
Return the number of products in the "Products" table:
SELECT Count(ProductID) AS NumberOfProducts FROM Products;
Try it Yourself »
Definition and Usage
The Count() function returns the number of records returned by a select query.
Note: NULL values are not counted.
Syntax
Count(expression)
Parameter Values
Parameter | Description |
---|---|
expression | Required. A field or a string value |
Technical Details
Works in: | From Access 2000 |
---|