How to Use the Wizard to Create a Crosstab Query in Microsoft Access

Crosstab queries make it easier to view records by displaying the information in a compact view similar to a spreadsheet. With the wizard, you just need to answer some questions to create the query. These instructions apply to Access 97.

Difficulty: Moderate

Instructions

Things You'll Need:

• Microsoft Access

1. Open the Database window.

2. Click on the Queries tab. A query window opens.

3. Click New. A New Query dialog box appears.

4. Click Crosstab Query Wizard.

5. Follow the instructions that the Wizard offers. First, select the table or query that contains the fields you want to use. Click Next.

6. Select up to three fields to be used as row headings. For example, you could sort addresses by Country and then by Region. Click Next.

7. Select the fields you want as column headings. Click Next.

8. Enter any calculations you want performed. Click Next.

9. Name your Query. Click Finish. Your query appears.

Tips & Warnings

• If your query isn't the way you wanted it, you can change the query in Design view.
• You can also create crosstab queries using the Pivot Table Wizard.
• To create the query from scratch, see "How to Create a Crosstab Query From Scratch in Microsoft Access."