Database Reference
In-Depth Information
Now let's filter the table to display only the records for customers with last names
beginning with the letter
S
or
B
who live in California or Washington.
8
Click the
CustomersFilter1
tab to switch to the filter page.
9
In the
or
row of the
LastName
field, enter
b*
, and then press
Enter
.
You have entered two criteria involving two fields in the design grid.
10
In the
Sort & Filter
group, click the
Apply Filter
button to apply the filter to the
Customers
table. Then notice that the result includes records for all customers with
last names that begin with
S
or
B
, but some of the
B
names live in
Montana
and
Oregon
.
11
Click the
CustomersFilter1
tab to switch to the filter page, and look carefully at the
design grid.
The filter first works with the two criteria in the Criteria row and searches for custom-
ers with names beginning with
S
who live in California or Washington. Then it works
with the criteria in the Or row and searches for customers with names beginning with
B
, regardless of where they live. To get the results we want, we need to repeat the
criterion from the Region field in the Or row.
12
In the
or
row of the
Region
field, enter
ca or wa
, and then press
Enter
.
13
Apply the filter, which now correctly displays only the records for customers with last
names beginning with
S
or
B
who are located in
California
or
Washington
.
14
Close the
Customers
table, clicking
Yes
when prompted to save changes to the
design of the table.
CLEAN UP
Close the GardenCompany04 database.
