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.

Connect with an expert
Contact us
Expand your skills
Explore training

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.