Use a query to count specific Access records

The Count function helps you easily create a query that, based on any criteria, sums up the number of Access records you have. For example, to create a query to find out how many female technicians your company employs, follow these steps:

1. Open the Employees database.
2. Click Queries Under Objects in the Database window.
3. Click the New button and then click OK.
4. Select the Employees table and the click Add.
5. Click Close.
6. Click in the first empty field cell of the Query Design grid.
7. Type Count(*).
8. Press [Tab].
9. Double-click Expr1 and type Total Number Of Female Technicians.
10. Double-click the Gender field in the Field list.
11. Click to deselect the Gender Field Show check box.
12. Type Female in the Gender Criteria cell.
13. Save and close the query.

Miss an Access tip?

Check out the Microsoft Access archive, and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.