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 |
| = |
Equal to |
| > |
Greater than |
| < |
Less than |
| >= |
Greater than or equal to |
| <= |
Less than or equal to |
| <> |
Not equal to |
