Retrieve the count of products in the “Products” table.
| SELECT Count(ProductID) AS NumberOfProducts FROM Products; |
The Count() function returns the number of non-null records retrieved by a select query.
| Count(expression) |
|
Parameter |
Description |
|
expression |
Required: This refers to either a field or a string value. |
|
Works in: |
From Access 2000 |