Microsoft Office Tutorials and References
In Depth Information
Fine-tuning Criteria with AND and OR
Figure 17-5:
Finding
records that
match any
one of two
or more
criteria.
To combine AND with OR in a criteria range, use two or more columns and
two or more rows. Figure 17-6 shows a criteria range that finds all records
where Class is Accounting 101 and Teacher is either Mr. Harris or Mr.
Richards.
Figure 17-6:
Combining
AND and OR
criteria.
To define a criterion that uses ranges, use these numerical comparison
operators:
< for less than
> for greater than
<= for less than or equal to
>= for greater than or equal to
Of course, you can apply these to fields with numerical values. Figure 17-7
shows two criteria areas. The upper one matches all records where Final
Grade is 90 or higher. The lower one matches all records where Final Grade
is equal to or greater than 80 and less than 90.
Figure 17-7:
Defining
numerical
range
criteria.
Search JabSto ::




Custom Search