Microsoft Access 2010 Bible

Part I: Access Building Blocks

190

FIGURE 5.2

Using And and Or criteria in a query

Or And

FIGURE 5.3

Creating complex criteria without using the And/Or operators

Or And Or

In any case, the queries in Figures 5.2 and 5.3 are equivalent and return the same data.

One confusing aspect about the query in Figure 5.3 is that the criteria in the Category column

must appear twice, once for each value in the State column. If the Category criteria appeared only

once, perhaps in the same row as “AZ” in the State column, the combined criteria would be inter-

preted as:

(State = “AZ” and Category <> “Cars”) Or (State = “CA”)