Free E-Books

Because you placed data for both criteria on the same row, Access interprets this as an And
operation??”where both conditions must be True. If you click on the Datasheet View command,
you see that you only have seven records in the query??™s results.
197
Using Operators and Expressions in Access 5
Specifying Or criteria across fields of a query
Although the Or operator isn??™t used across fields as commonly as the And operator, occasionally
Or is very useful. For example, you may want to see records of any vehicles bought by contacts in
Connecticut or you may want to see records on SUVs, regardless of the state they live in. To create
this query, follow these steps:
1. Use the query from the previous example, emptying the two criteria cells first.
2. Add Category from tblProducts.
3. Click the Criteria: cell of State.
4. Type CT in the cell.
5. Click in the Or: cell for Category (one line below the CT example).
6. Type SUV in the cell.
Your query should resemble the query shown in Figure 5-17.


Pages:
518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542