Creating a Crosstab Query
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).
Build a Crosstab Query
Click the Create tab.
Click Query Wizard.
Click Crosstab Query Wizard.
Click OK.
Click the table or query to provide the values for your crosstab ...
Get Microsoft® Office Access™ 2007 Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.