Microsoft Office Tutorials and References
In Depth Information
To Use a Comparison Operator in a Criterion
Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches). In
the last query, for example, you were requesting those clients whose current due amount is equal to 0 (zero). If you
want something other than an exact match, you must enter the appropriate comparison operator . The comparison
operators are > (greater than), < (less than), >= (greater than or equal to), <= (less than or equal to), and NOT (not
equal to).
The following steps use the > operator to fi nd all clients whose amount paid is more than $20,000.00.
1
Return to Design view.
Erase the 0 in the Current Due
column.
View
button
View
button
Type >20000 as the criterion
for the Amount Paid fi eld
(Figure 2–28).
criterion for
Amount Paid fi eld
comparison
operator
criterion for
Current Due
fi eld erased
criterion for
Current Due
fi eld erased
Figure 2–28
2
View the query results
(Figure 2–29).
I
View
button
Experiment
Return to Design view. Try a
different criterion involving a
comparison operator in the Amount
Paid fi eld and view the results.
When fi nished, return to Design
view, enter the original criterion
(>20000) in the Amount Paid fi eld,
and view the results.
query
results
only clients whose
Amount Paid is over
$20,000 are included
Figure 2–29
 
Search JabSto ::




Custom Search