When you build a query, you can enter conditions and customize the rows of data retrieved. As you customize the data to retrieve, you may want a column to match a specific value, and you may want a column to be greater than a specific value.
For example, if you had a column named ZIPCODE, you could specify ZIPCODE < 40000 to select all zip codes under 40000.
Add conditions to your query in from the Where Clauses dialog box in the Query Builder - Fields page.
You can combine several Where clauses with the logical operators AND, OR, or ELSE. For multiple Where clauses, select an operator under Logical Operator. (See Joining Where Clauses.)
To change the order in which the Where clauses appear, select a Where clause and click Move Up or Move Down. In general, you should put your most restrictive Where clauses first.