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.

1

•
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).

Recruiter

Number

ﬁ eld added

Amount

Paid ﬁ 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 ﬁ eld

(Figure 2–71).

entry in Total

row is Where

criterion (recruiter

number must be 21)

Figure 2–71