Microsoft Office Tutorials and References
In Depth Information
View the query results
(Figure 2–72).
average amounts
paid by clients of
recruiter 21
Figure 2–72
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 fi eld to be used for grouping.
The following steps calculate the average amount paid for clients of each recruiter.
1
Return to Design view and clear
the design grid.
Include the Recruiter Number
fi eld in the query.
Recruiter
Number fi eld
Amount
Paid fi eld
Include the Amount Paid fi eld in
the query.
group by
recruiter
number
Select Avg as the calculation in
the Total row for the Amount
Paid fi eld (Figure 2–73).
calculate
average
Why didn’t I need to change the
entry in the Total Row for the
Recruiter Number fi eld?
Group By currently is the entry
in the Total row for the Recruiter
Number fi eld, which is correct;
thus, it was not changed.
Figure 2–73
 
Search JabSto ::




Custom Search