Using the Crosstab Query Wizard


The Crosstab Query presents data in a summarized row-and-column format similar to a spreadsheet. It is useful for querying large amounts of data and for figuring totals or averages. Crosstab queries may take a little getting used to, but they are very useful for summarizing sales and purchasing data.



To use the Crosstab Query Wizard:

  1. Start the Crosstab Query Wizard by clicking the New Object toolbar button arrow. Select Query. Click Crosstab Query Wizard, and click OK.
  2. Click the table or query that contains the fields you want to display. Click Next.
  3. Pick the field that will appear as the row headings. Click Next.
  4. The table column headings will correspond to values from a specific field. Click the field you want to use for column values. Click Next.
  5. Finally, pick the value that should be calculated for each row and column intersection. Click Next.
  6. Give the query a name and click Finish to see the results.


If you want to create a crosstab query for fields from different tables, first create a simple query that combines the fields you want. Then run the Crosstab Query wizard using the new query as its field base.

To start the Crosstab Query Wizard:

  1. Click the New button in the Queries window. Click Crosstab Query Wizard. Click OK.
  2. Select Query from the Insert menu. Click Crosstab Query Wizard. Click OK.