Databases Reference
In-Depth Information
To indicate that two criteria must both be true to select a record, place the conditions for each field in the
same Criteria row, as shown in Figure 2-9. In this case, you want the query to select those parts where the
value in the OnHand field is greater than 10 (which requires the use of the > comparison operator) and the value
in the Warehouse field is 3.
38
Criterion to select
records in which the
Warehouse value
equals 3
Criterion to select
records in which the
OnHand value is
greater than 10
Because the criteria
are in the same Criteria
row, both criteria must be
true to select a record
FIGURE 2-9
Query that uses an AND criterion
The query results appear in Figure 2-10.
Only parts with more
than 10 units on hand and
located in warehouse 3
are included
FIGURE 2-10
Query results
EXAMPLE 5
List the description, on hand value, and warehouse number for all parts that have more than 10 units on hand
or
that are located in warehouse 3.
