Microsoft Office Tutorials and References
In Depth Information
• View the query results
paid by clients of
To Use Grouping
Another way statistics often are used is in combination with grouping; that is, statistics are calculated for
groups of records. You may, for example, need to calculate the average amount paid for the clients of each recruiter.
You will want the average for the clients of recruiter 21, the average for clients of recruiter 24, and so on.
Grouping means creating groups of records that share some common characteristic. In grouping by Recruiter
Number, for example, the clients of recruiter 21 would form one group, the clients of recruiter 24 would form a
second, and the clients of recruiter 27 form a third group. The calculations then are made for each group. To indicate
grouping in Access, select Group By as the entry in the Total row for the ﬁ eld to be used for grouping.
The following steps calculate the average amount paid for clients of each recruiter.
• Return to Design view and clear
the design grid.
• Include the Recruiter Number
ﬁ eld in the query.
Number ﬁ eld
Paid ﬁ eld
• Include the Amount Paid ﬁ eld in
• Select Avg as the calculation in
the Total row for the Amount
Paid ﬁ eld (Figure 2–73).
Why didn’t I need to change the
entry in the Total Row for the
Recruiter Number ﬁ eld?
Group By currently is the entry
in the Total row for the Recruiter
Number ﬁ eld, which is correct;
thus, it was not changed.