Posted by
MS Access
Count()
Function
Example
Return the number of products in the “Products” table:
SELECT Count(ProductID) AS NumberOfProducts FROM Products;
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 |
|---|