Page 5 of 11PREVNEXT

Queries III: Use expressions and other criteria

Mathematical comparison operators


It's easy to retrieve data based on how it compares to a value, such as all grades equal to or lower than 70. The picture shows you how to do this. Open your query in Design view, and in the Criteria cell, enter a comparison operator and a value. For example:

Callout 1 Greater than 40.
Callout 2 Greater than or equal to 40.
Callout 3 Less than or equal to 40.
Callout 4 Not equal to 40.

You'll use comparison operators in the practice, and the Quick Reference Card has a complete list.

Page 5 of 11PREVNEXT