Microsoft Office Tutorials and References
In Depth Information
To Use a Compound Criterion Involving OR
To combine criteria with OR, the criteria must go on separate lines in the Criteria area of the grid. The
following steps use an OR criterion to fi nd those clients whose amount paid is greater than $20,000.00 or whose
recruiter is recruiter 21 (or both).
1
Return to Design view.
If necessary, click the Criteria entry
for the Recruiter Number fi eld
and then use the BACKSPACE key
or the DELETE key to erase the
entry (“21”).
View
button
Click the or: row (the row below
the Criteria row) for the Recruiter
Number fi eld and then type 21 as
the entry (Figure 2–32).
because criteria are
on separate lines,
only one needs to
be true
criterion for
Amount Paid fi eld
criterion for
Recruiter
Number fi eld
or row
Figure 2–32
2
View the query results
(Figure 2–33).
View
button
query
results
only clients whose amount
paid is more than $20,000
or whose recruiter number
is 21 are included
Figure 2–33
 
Search JabSto ::




Custom Search