1-866-245-5224 sales@keystonelearning.com

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

     
  1. 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

    7.       Click Next

 

Figure 50. Crosstab Query Wizard - Choose Column Heading

 

    8.       Choose the field to use as the column headings

    9.       Click Next

 

Figure 51. Crosstab Query Wizard - Type a Name for the Query

 

    10.   Type a name for your Crosstab Query

    11.   Click Finish