Crosstab Query Wizard:

Select the Row Headings

The Row Headings will be shown on the left side of the Crosstab layout. All of the Fields in the Table are available. You can select more than one Field if you wish.

 

4. Try it: Select the Row Headings

Select a Field: Genre.

 

What Do You See? The sample layout shows the position of the Genre data.

 

Click Next. Keep going...

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Create a Crosstab Query

Create ->Queries ->Query Wizard->Crosstab Query Wizard