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.
Create a crosstab query by using a wizard
Create a crosstab query without using a wizard