Microsoft Office Tutorials and References
In Depth Information
Using the Crosstab Query Wizard
Figure 4-1:
This
Crosstab
query
shows sales
by product
and quarter.
If you want to aggregate data without using a Crosstab query, see Chapter 2
of this minibook, as well as the forms and reports chapters in Books IV
and V.
Using the Crosstab Query Wizard
The Crosstab Query Wizard provides an automated way to create a Crosstab
query. The wizard works only with one table or query. If the fields you want
to use in the Crosstab query aren’t in one table, you have to create a query
that combines those fields before you use the Crosstab Query Wizard.
Although the wizard gives you the option of aggregating date data (taking
a Date/Time field and combining the data into months), you don’t have to
write an expression to aggregate data yourself. The Orders table, for
example, saves the time and day when an order is submitted. The Crosstab Query
Wizard takes that date field and converts it to just the month (or year,
quarter, or day). For the option to aggregate data by date (such as day, month,
quarter, year), you must use the date field as a column heading.
Start the Crosstab Query Wizard by following these steps:
1. Click the Query Wizard button in the Queries group on the Create tab
of the Ribbon.
The New Query dialog box opens.
2. Select the Crosstab Query Wizard option and then click OK.
Access starts the Crosstab Query Wizard, shown in Figure 4-2.
3. Select the table or query that contains all the fields you need for your
Crosstab query and then click Next.
If you create a query to hold the fields you need, select the Queries or
Both radio button to see the query name.
All your fields for the Crosstab query must be in a single table or query.
Search JabSto ::




Custom Search