# How to Create Crosstab Query MS Access

> To create a crosstab query in MS Access, open your database, go to the Create tab, and click Query Wizard in the Queries group. Select Crosstab Query Wizard, choose your data source, and follow the prompts to select row headings, a column heading, summary values, and an aggregation function before naming and finishing the query.

Canonical: https://livedemo.ai/tutorials/how-to-create-crosstab-query-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a395aab56e05a00fdfadc/preview?step=1

## 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. Click 'Next'.
6. Select one or more fields for the row headings. Click 'Next'.
7. Select a single field for the column headings. Click 'Next'.
8. Select a field for the summary values. Choose an aggregation function. Click 'Next'.
9. Provide a name for your crosstab query. Click 'Finish' to view the results.
10. By following these steps, you can create a crosstab query in MS Access.