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

Filtering Table Data

Access lets you apply a filter to specify the records that appear in the Datasheet view of a table or a query result set. For example, if you want to view only those customers located in Germany, you use a filter to limit the displayed records to only those whose Country field contains the text Germany. Access gives you three different ways to apply filters to the data in a table:

Figure 6.8. The Replace dialog.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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