Free E-Books

FIGURE 5-1
The QBE pane shows a simple criterion asking for all vehicles where the Category is Cars.
Understanding complex criteria selection
You build complex query criteria using any combination of the available operators shown in Table
5-4. For many queries, complex criteria consist of a series of Ands and Ors, as in these examples:
n State must be Connecticut or Texas
n City must be Sunnyville and state must be Georgia
n State must be MA or MO and city must be Springfield
These examples demonstrate the use of both logical operators: And/Or. Many times, you can create
complex criteria by entering example data in different cells of the QBE pane. Figure 5-2 demonstrates
how to create complex And/Or criteria without entering the operator keywords And/Or at
all. This example displays all the buyers and their sales that satisfy the following criteria:
177
Using Operators and Expressions in Access 5
Live in either the state of Connecticut (CT) or the state of Massachusetts (MA) and whose
product category is not a car.


Pages:
484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508