Using the Crosstab Query Wizard

To use the Crosstab Query Wizard:

1. Click the New Object toolbar button arrow.
2. Select Query.
3. Click Crosstab Query Wizard.
4. Click OK.
5. Click the Table or Query that contains the fields you want to display.
6. Click Next.
7. Select the field that will appear as the row headings.
8. Click Next.
9. Select the field you want to use for column headings.
10. Click Next.
11. Pick the Function that should be calculated for each row and column intersection.
12. Click Next.
13. Give the query a name.
14. Click Finish to see the results.

Start the Crosstab Query wizard by clicking the New Object toolbar button arrow. Select Query; then click Crosstab Query Wizard in the New Query box, and click OK. Select the table or query that contains the fields you want to display and click Next. Select the field that will appear as row headings. Click Next. Select the field that contains the values you want to use as column headings. Click Next. Select the value that should be calculated for each row and heading intersection. Finally, name the query, and click Finish to see the results.