Create a crosstab query using a wizard

For an example of a crosstab query, click .

1. In the Database window, click Queries under Objects, and then click New on the Database window toolbar.
   
   
2. In the New Query dialog box, click Crosstab Query Wizard.
   
   
3. Click OK.
   
   
4. Follow the directions in the wizard dialog boxes. In the last dialog box, you can choose to run the query or see the query's structure in Design view.

   If the resulting query isn't exactly what you want, you can rerun the wizard or change the query in Design view. For more information on changing a query in Design view, click .

To troubleshoot problems with the query, click .

Tip   You can display crosstab data without creating a separate query in your database either by using the PivotTable Wizard in a form or by creating a PivotTable list in a data access page. With a PivotTable form or PivotTable list, you can change row and column headings on demand to analyze your data in different ways. For information on creating a PivotTable form, click .

For information on creating a PivotTable list on a data access page, click .