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:

picture of count function syntax =Count([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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!