Home > Sample chapters > Microsoft Office > Access

Selecting Data Using Queries in Microsoft Access 2013

Creating a crosstab query with the Query Wizard

Crosstab queries can be constructed manually. However, it is simpler to use the Query Wizard to create the query, which you can later change in design view.

Create a crosstab query

  1. Click the Create tab.

  2. Click Query Wizard.

  3. In the New Query popup window, click Crosstab Query Wizard.

  4. Click OK.

  5. In the Crosstab Query Wizard, click Queries.

  6. Select a query and click Next.

  7. Select one or more columns to act as row headings, and click Next.

  8. Select one column to act as the new column heading, and click Next.

  9. Select the column to summarize.

  10. Select the calculation type to use, and click Next.

  11. Type a name for your query, and click Finish.

  12. Select design view.

  13. In the query Column Headings property field, type a fixed set of headings.