How to Create a Crosstab Query in Design View in Access
Design View offers more options for creating crosstab queries. Here's how to create a crosstab query in Design View.
A crosstab query is a special type of query that allows you to display data in a more compact way than with a normal select query.
There's a Crosstab Query Wizard, but it is somewhat limited with what you can do. In many cases, you are probably better off creating your crosstab query from Design View (or starting with the wizard, then modifying it in Design View).
Here's a quick demonstration of how to create a crosstab query from scratch in Design View.
Applying this technique on the above query will result in all 12 months of the year being displayed, even though some months don't have any data to display.