The basic means of storing and presenting data in Access is the table, which is essentially a list of information about a group of "things" (such as customer orders) related to a single primary key value. Another way to present data is in a Crosstab query, which relates one value (such as a total or average) with two other values (such as a customer and a month).
Click the Create tab.
Click Query Wizard.
Click Crosstab Query Wizard.
Click the table or query to provide the values for your crosstab ...