Quick summary
The COUNT function in MS Access lets you tally records in a query without writing SQL manually. Using Query Design and the Totals option, you can count field values in just a few clicks.
Steps
- Go to the Create tab in the MS Access ribbon.
- Select the Query Design button to open a new query.
- Add the table or query containing the field you want to count by clicking Add Selected Tables.
- Drag the desired field into the query grid.
- Click the Totals button (Σ symbol) in the ribbon to enable grouping options.
- In the Total row for the field, select Count from the dropdown menu.
- Run the query by clicking the Run button to see the count results.
