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.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.