854 Chapter 28 Display Data
Only the 30 records for customers who live in postal codes starting with 880 are displayed in
the table.- In the Sort & Filter group, click the Toggle Filter button to remove the filter and
display all the records.
Now let’s display only the records of the customers who live outside of the United
States. - In the Country field, right-click any instance of USA, and then click Does Not
Equal "USA".
Tip In this case, it is easy to right-click the text you want to base this filter on. If the text
is buried in a large table, you can quickly locate it by clicking the Find button in the Find
group on the Home tab, entering the term you want in the Find What box in the Find
And Replace dialog box, and then clicking Find Next.
Access displays the records of all the customers from countries other than the
United States (in this case, only Canada). - Remove the filter, and close the Customers table, clicking No when prompted to
save your changes. - Open the Orders table in Datasheet view.
- In the EmployeeID field, right-click 7 , and then click Equals 7.
Twenty records are displayed in the filtered table.