862 Chapter 28 Display Data
- Click the CustomersFilter1 tab to switch to the filter page.
- In the or row of the LastName field, type b*, and then press Enter.
We want to 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.The design grid with three criteria.- In the Sort & Filter group, click the Toggle Filter button to apply the filter.
On the Customers table page, 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.- 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 cus-
tomers 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. - In the or row of the Region field, type ca or wa, and then press Enter.
- Apply the filter.
Access switches to the Customers table page and displays only the records for
customers with last names beginning with S or B who are located in California
or Washington.- Close the Customers table, clicking Yes when prompted to save changes to the
design of the table.
CLEAN UP Close the GardenCompany04 database.
Tip If you are likely to want to use a filter again, you can save it as a query. On the Home tab,
in the Sort & Filter group, click the Advanced Filter Options button, click Save As Query, assign
the query an appropriate name, and click OK. Then you can run the query to display the filtered
results at any time.