The Count function helps you easily create a query that, based on any criteria, sums up the number of Access records you have. Here's how to use it.

When you execute the query, Access will display the results of the calculation in the results. Figure A You can perform all sorts of calculations in a query using calculated fields.