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

Filtering Out Records

Instead of displaying all the records in a table, you can use a filter to display only those records that you want to see. You can display records based on a specific value in one field or on multiple values in multiple fields. You can filter by selecting the field value on which to base the filter in Datasheet view or by using Filter By Form to help you create more complex filters involving multiple field values. After you apply a filter, Access displays only those records that match your specifications. You can remove a filter to return the datasheet to its original display.

Filter a Table by Selection

Display the table in Datasheet view.

Right-click the field value on which you want to base the filter.

Click Filter By Selection. Notice that the bottom of the Table window tells you the number of records matching your filter criteria. Also, the notation FLTR in the status bar indicates that a filter is currently in effect.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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