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 ﬁ eld, ﬁ rst
you select Where as the entry in the Total row for the ﬁ 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.
• Return to Design view.
• Include the Recruiter Number ﬁ eld
in the design grid.
• Click the Total box arrow in the
Recruiter Number column to
produce a Total list (Figure 2–70).
ﬁ eld added
Paid ﬁ eld
allows you to
enter a criterion
• Click Where.
• Type 21 as the criterion for
the Recruiter Number ﬁ eld
entry in Total
row is Where
number must be 21)