Page 9 of 23PREVNEXT

Queries II: Limit your data and calculate values

Query using comparison operator; query results

Callout 1 This query using a comparison operator...
Callout 2 ... retrieves products with unit prices greater than $60.

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
Page 9 of 23PREVNEXT