A crosstab query allows you to summarize the contents of fields that contain numeric values, such as Date fields or Number fields. In this type of query, the results of the summary calculations are shown at the intersection of rows and columns . Crosstab queries can also involve other functions such as the average, sum, maximum, minimum, and count. You cannot update crosstab queries. The value in a crosstab query cannot be changed in order to change the source data.
Create a Crosstab Query