Find specific data using a filter

Office Data Access Pages

By using a filter, you can find records based on whether they contain a specific value in a particular field. For example, you can find all records that have "Germany" in the Country field. When you apply the filter, only the records that contain the value you selected will appear in the data access page. Once you remove the filter, all the records will be displayed again. For grouped data access pages, you can filter the list of groups (the group headings) or the records within groups.

  1. Do one of the following:

    ShowIn an ungrouped page

    ShowIn a grouped page

  2. To further narrow the subset of records, continue selecting fields and clicking Filter By Selection Button image until you have just the records you want.

    For example, if you want to see records only for customers in Germany with a required date of 5/12/98, select "Germany" in the Country field, click Filter By Selection, select "5/12/98" in the Required Date field, and then click Filter By Selection again.

Notes

  • If you select only part of the value in a field, the data access page still uses the entire field value for filtering.
  • You can remove the filter and then reapply it during the same working session.
  • If you browse to another data access page, you'll lose the filter.
  • This procedure doesn't apply to a PivotTable list, spreadsheet, or chart. These features can be filtered independently from the rest of the data on the data access page and may also support additional filtering capabilities. For more information, click Help Button image on that component's toolbar.