• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 33. Working with Records > Creating a Filter

Creating a Filter

A filter displays only certain records from a table according to the criteria you set. For example, you can use a filter to display only employees who live in Chicago.

To create a filter by selecting the criterion:

1.
While viewing a form or table, click a field to use its contents as the criterion for the filter (Figure 33.12).

Figure 33.12. Select a value in a field to filter by that value.


2.
Click the Filter By Selection button on the Access toolbar (Figure 33.13).

Figure 33.13. Click the Filter By Selection button…


or

From the Records menu, choose Filter, and then choose Filter By Selection from the Filter submenu (Figure 33.14).

Figure 33.14. …or choose Filter By Selection from the Filter submenu.


The records are filtered and the Apply Filter button is replaced by the Remove Filter button.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint