You create a crosstab query with a wizard or from scratch in the query design grid. In the design grid, you specify which field's values will become column headings, which field's values will become row headings, and which field's values to sum, average, count, or otherwise calculate.

Example of how to fill in the query design grid for a crosstab query

More information

Create a crosstab query by using a wizard

Create a crosstab query without using a wizard