Microsoft Office Tutorials and References
In Depth Information
Creating a Crosstab Query in Design View
Figure 4-7:
This
Crosstab
query
shows sales
of each
product by
quarter.
Look at the results of the Crosstab Query Wizard in Design view to get
ideas about how to create a Crosstab query from scratch. You can get your
Crosstab query started with the Crosstab Query Wizard and then put the
finishing touches on the query in Design view, which is covered in the
next section.
You can format your crosstab query data in Design view by right-clicking the
column that defines the value in the table, choosing Properties from the
contextual menu, and changing the format on the property sheet.
Creating a Crosstab Query in Design View
A simple Crosstab query has three fields:
One used for row headings (Date, for example).
One used for column headings (Product, for example).
The Value field, which contains the data that you want to appear in the
cells of the table (such as an item subtotal). Tell Access how to
summarize your data in the Crosstab query by choosing Sum, Avg, Min, Max,
Count, StDev, Var, First, or Last.
You also have the option of using an expression for any fields in the
Crosstab query design. See Chapter 2 of this minibook for more information
on creating a field with an expression.
Follow these steps to create a simple Crosstab query:
1. Create a new select query in Design view with the tables or queries
that contain the fields you want to use in the Crosstab query.
Chapter 1 of this minibook covers creating select queries.
Search JabSto ::




Custom Search