Administrator: Receipts (Start) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

Crosstab Queries The movie table uses the Rating and the Genre fields to identify the movies. A Crosstab query compares that data in rows and columns.   Try it: Create a Crosstab Query   Select the following options: Row header: Genre Column header: Rating Field to calculate: Movie Function: Count   Save the query: MoviesCrosstabQ   What do you see? The Crosstab query wizard created a table that counts the movies in each Genre. This is an interactive table: at the top of each Column Header there are drop down lists for sorting and filters. Create ->Query Wizard ->Crosstab Query Wizard