Suppose you want to send a newsletter to some of your customers in France, but only to people who own their own stores. You can find that data by filtering your result set, but it's faster and easier to set multiple conditions — criteria that your data must meet to be included in your results.
When you set multiple conditions, you also use logical operators such as And, Or, and In. These operators help you retrieve just the data you need, and you'll see how they work in a little while. For now, let's add conditions to a query:
Open your query in Design view, and in the Criteria
cell for the field where the first condition applies, enter your criteria. Remember that the criteria you enter has to match a value in your data.
Do the same for any other fields. For example, you could type owner
under the ContactTitle
field and France
under the Country
When you run the query, Access uses the And
operator to retrieve data that meets your conditions.
Access uses the And operator whenever you place all your criteria on the Criteria row. Next, we'll look at how you can use the Or operator.