Microsoft Office Tutorials and References
In Depth Information
To Use Criteria in Calculating Statistics
Sometimes calculating statistics for all the records in the table is appropriate. In other cases, however, you will
need to calculate the statistics for only those records that satisfy certain criteria. To enter a criterion in a fi eld, fi rst
you select Where as the entry in the Total row for the fi eld, and then enter the criterion in the Criteria row. The
following steps use this technique to calculate the average amount paid for clients of recruiter 21.
1
Return to Design view.
Include the Recruiter Number fi eld
in the design grid.
Click the Total box arrow in the
Recruiter Number column to
produce a Total list (Figure 2–70).
Recruiter
Number
fi eld added
Amount
Paid fi eld
Total box
arrow
calculate
average
Total list
selecting Where
allows you to
enter a criterion
Figure 2–70
Click Where.
Type 21 as the criterion for
the Recruiter Number fi eld
(Figure 2–71).
entry in Total
row is Where
criterion (recruiter
number must be 21)
Figure 2–71
Search JabSto ::




Custom Search