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

Filtering Table Data

Access enables you to apply a filter to specify the records that appear in 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:

  • Filter by selection is the fastest and simplest way to apply a filter. You establish the filter criteria by selecting all or part of the data in one of the table's fields; Access displays only records that match the selected sample. You can filter records based only on criteria in a single field of the table with a filter by selection.

  • Filter by form is the second-fastest way to apply a filter. You enter the filter criteria into a blank datasheet form of the table; Access displays records that match the combined criteria in each field. Use a filter by form to quickly filter records based on criteria in more than one field.

  • Advanced filter/sort is the the most powerful yet most difficult type of filter to use. With an advanced filter/sort, you can make an Access filter do double duty because you also can add a sort order on one or more fields.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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