How to Create Crosstab Query MS Access

Quick summary

A crosstab query in MS Access lets you summarize and cross-tabulate data from a table or query using the built-in Crosstab Query Wizard. This tutorial walks through every step — from opening the wizard to choosing row headings, column headings, and an aggregation function — so you can generate structured summary reports quickly.

Steps

1. Launch MS Access and open the database containing the data you want to analyze.
2. Go to the 'Create' tab on the ribbon.
3. In the 'Queries' group, click on 'Query Wizard'.
4. Select 'Crosstab Query Wizard' from the dialog box and click 'OK'.
5. Choose the table or existing query that contains the data you want to use for the crosstab query, then click 'Next'.
6. Select one or more fields for the row headings, then click 'Next'.
7. Select a single field for the column headings, then click 'Next'.
8. Select a field for the summary values and choose an aggregation function, then click 'Next'.
9. Provide a name for your crosstab query, then click 'Finish' to view the results.