When you run a report, you often do not want every available record displayed or printed. Selecting a subset of records to work with is called filtering. The Filtering page of the report wizards allows you to specify which records are included in the report.

This page has the following options:

  • Filter conditions: this section has filter conditions that determine which records to include in the report.

  • Exclude conditions: this section has filter conditions that determine which records to exclude in the report.

  • Fields: this drop-down list allows you to determine which fields are displayed when creating a filter condition. Show all fields means display all fields whether they are included in the report or not, Show selected fields only means display only those fields in the Selected Fields list for the report, and Show selected tables only means display only those tables being used in the report.

See the Creating a Filter topic for information on creating filter conditions and exclude conditions.