Use the COUNT function

If you want count the number of items returned by a query, use the COUNT function. For example, you might want to know the number of open orders:

Where, Orders can refer to either a field (column) or an expression. Here's more about adding functions to expressions.

Using the function in expressions lets you use it in multiple ways. For example, if you have a Due Date field on a form, you can count how many days are left until the Due Date. If you'd like some training on this, see using functions and calculated fields in queries.

Note:  The COUNTIF function is an Excel function and isn't available in Access. Instead, you can use the Dcount function.