Microsoft Office Tutorials and References
In Depth Information
Using the Crosstab Query Wizard
Choose one of the options listed. The Date/Time option shows data by
unique date and time. Data isn’t grouped at all when you pick this option
unless you have data with exactly the same time and date.
7. In the new window that appears, shown in Figure 4-6, choose the field
whose values you want to see grouped by the row and column
headings that you selected.
you want to
The field you select usually contains numerical data that can be
aggregated in some way (added, averaged, and so on). An exception occurs if
you want to count instances; in that case, the field doesn’t need to
Figure 4-6 uses the ExtPrice field, which is price × quantity — the
dollar amount of sales for each product.
8. Select a grouping method in the Functions list.
You can find out more about these functions in Chapter 2 of this
minibook. You can easily change this function in Design view if you change
your mind after you view the Crosstab query.
9. Choose whether to include row sums by selecting the check box on
the same page as the function choices and then click Next.
If you choose to include row sums, Access creates an extra column that
contains the sum of the row — in this example, the total sales for the
10. Name the query (or use the name that Access suggests), choose how
you want to view the query (viewing the query datasheet or viewing
the query in Design view), and then click Finish to see the Crosstab
Figure 4-7 shows how the sample Crosstab query turned out.