What is a crosstab query and when would you use one?

A crosstab query displays summarized values (sums, counts, and averages) from one field in a table and groups them by one set of facts listed down the left side of the datasheet and another set of facts listed across the top of the datasheet.

For information on creating a crosstab query with a wizard, click . For information on creating a crosstab query from scratch, 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 .