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