Access 2007: Creating a Crosstab Query

Access 2007: Creating a Crosstab Query

A crosstab query is a special type of query that displays its results in a grid similar to an Excel worksheet. Crosstab queries summarize your values and then group them by two sets of facts — one set down the side, and the other across the top.

Figure 46. Crosstab Query Sample

When you create a crosstab query, you typically include data from more than one table, and you always include three types of data: the data used as row headings, the data used as column headings, and the values that you want to summarize or otherwise compute.

Creating A Crosstab Query

Choose the Query Wizard command in the Other group on the Create tab

Figure 47. New Query - Select Crosstab Query Wizard

2.Choose Crosstab Query Wizard

3.Click OK

Figure 48. Crosstab Query Wizard - Choose a Table/Query

4.Choose the table on which you want to base your Crosstab Query

5.Click Next

Figure 49. Crosstab Query Wizard - Choose Row Headings

6.Move the fields from the Available Fields column to the Selected Fields column that you want to display as row headings