Crosstab Query Wizard:

View the Results

8. Try it: View the Results

The Crosstab Query shows the Genre in the Rows and the Ratings in the Columns.

 

There is a Column that Counts the Total for each Genre. In this example, there are 13 Action movies in tblMovies.

 

The Crosstab Query Counts the number of movies in each Rating, as well. In this example there is one G Rated Comedy and 35 G Rated Family films.

 

What Do You See? The Row Header, Genre, has a Filter. You can use the drop down to select one, some or all of the Genres if you wish.

 

OK, Close the Crosstab Query. If you are prompted to Save the Query, click Yes.

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

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Create a Crosstab Query