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 Query Design You can learn as much from taking something apart as you can by putting it together. What does a Crosstab query look like in Design View?   Try it: An interesting view Open the Crosstab query in Design View.   Look at the differences in the Total options: The Row and Column Headings use Group By. The second Row Heading uses Count to calculate the number of movies in each Row.   Try it: Switch the Row and Column Headings Make Column 1 Rating and Column 2 Genre. This works like a PivotTable, doesn't it?   Save your changes and test the query. Query Design Tools ->Design