Creating a custom crosstab query
1. In the design view, select the tables or queries that you want to add.
2. Drag the needed fields to the Field row of the QBE grid and specify criteria.
3. From Query menu, select Crosstab. Total and Crosstab rows display in grid .
4.Click the Crosstab cell for a field to use as a row heading, click the arrow, and select Row Heading from the list. You can choose more than one row heading.
5.Click the Crosstab cell for the field you want to use as a column heading, click the arrow, then select Column Heading from the list. The Total cell for both column and row headings must be set to Sum.
6.Click the Crosstab cell for the field to summarize, click the arrow, and then select Value. In a crosstab query, you can have only one field set to Value.
7.Click Total cell for the field to summarize, click the arrow, and select the type of total you want. The field must be a summary field and must contain a total.
8.Choose Run from the Query menu or click on the Run button on the toolbar.