It's easy to retrieve data based on how it compares to a value, such as all grades equal to or lower than 70.
You just type the comparison operator, such as <= (less than or equal to) before the value in the Criteria cell in the query design grid.
For example, to find all products that are priced above $60, you would type ">60" as criteria for the Unit Price field of a Products query.
|Common comparison operators
||Greater than or equal to
||Less than or equal to
||Not equal to