How to Create Crosstab Query MS Access
- George Apostolov
- 05 Sep 2025
Guide
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. Click 'Next'.
Select one or more fields for the row headings. Click 'Next'.
Select a single field for the column headings. Click 'Next'.
Select a field for the summary values. Choose an aggregation function. Click 'Next'.
Provide a name for your crosstab query. Click 'Finish' to view the results.
By following these steps, you can create a crosstab query in MS Access.
Create your first interactive demo in minutes
No credit card required • Start building today
