How to Create a Crosstab Query in Access 2003

A "crosstab query" in Microsoft Access 2003 compresses selected data into a viewable space. This allows you to quickly locate values and trends. To create a crosstab query in Access, follow these instructions.

Things You'll Need

• Microsoft Access 2003

Instructions

1. In the database window in Access 2003, click the "Queries" tab. Click "New" in the next window that appears.

2. Click "Design View" in the dialogue box, and then select "OK" to confirm your choice.

3. Select "Show Table" to view the tables you want to add to your query.

4. Double-click the objects you want to put in your query, then click "Close."

5. Under "Query Type" in the top toolbar select "Crosstab" in the dropdown menu.

6. Designate the fields you want to appear as rows in the grid by clicking the "Crosstab" row, then "Row Heading."

7. Do the same for the fields that will appear as columns by clicking on "Column Heading."

8. Select your final field--the one you will use for cross-tabulation--by clicking on the "Crosstab" row, then clicking "Value" to this field.

9. To view your final crosstab query, click the "View" icon on the top toolbar.

Tips & Warnings

• It is often faster to use the Query Wizard to create your crosstab queries in Microsoft Access 2003.

• For both the column and row headings, leave the default "Group By" as the Total Row.