THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Count() Function

❮ MS Access Functions

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 in a select query.

Syntax

Count(expression)

Note: If a record in the expression contains a NULL value, it is not included in the COUNT() calculation.

Parameter Values

Parameter Description
expression Required. A field or a string value

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

❮ MS Access Functions