Microsoft Office Tutorials and References
In Depth Information
Modifying a Crosstab Query
Figure 4-9:
This
Crosstab
query uses
two fields,
Company
and
Project
Description , to
categorize
hours
worked.
To use multiple fields to group data by row, specify more than one field as a
row heading in the design grid. Access figures out the order in which to use
the fields. The field on the “one” side of a one-to-many relationship displays
first. Figure 4-10 shows the design grid for the same query.
Book III
Chapter 4
Figure 4-10:
Specifying
two fields
as row
labels to
group hours
worked.
Adding aggregate columns
An aggregate column is an additional column in the query that totals rows
displayed in the query. You may add a column that calculated the total
number of the product sold to a query that displays sales by month and
product.
Search JabSto ::




Custom Search