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.
Note: The COUNTIF function is an Excel function and isn’t available in Access. Instead, you can use the Dcount function.