A Crosstab query displays summarized information in a table format that makes it easy to analyze and compare data. The Crosstab Query Wizard is usually much easier, but it does have some limitations:
If you need to use more than one table or query in the Crosstab query, you will first need to create a separate query that contains the tables you want to use.
You can't specify any limiting criteria when using the Crosstab Query Wizard. (But you can always modify the crosstab query in Design view and add the criteria yourself.)
If you select a date field, the Wizard will also ask you how you want to group the dates.
One of the most important steps in the Crosstab Query Wizard is determining which field you want to calculate where columns and rows intersect and the type of calculation you want to use to summarize the fields.