Using the Filter Wizard

To use the Advanced Filter Wizard:

  1. In the Filter Wizard dialog, select the primary table for the filter, and click OK.

    TIP: Use the Search field to narrow down the list of primary table names.

  2. Do any of the following:

    1. Next to the Preview field, click the folder icon.

    2. In the Filter Library dialog, select the filter to use, and click OK.

      TIP: You can edit an existing filter by selecting a filter and following the steps in Creating a filter below.

    3. In the Filter Wizard dialog, click Apply.
    4. Click OK.

    1. In the left side of the dialog, select the table column on which you want to base the filter.

      After you select a table column, the values in that column display in the right side of the dialog.

    2. In the right side of the dialog, type or select the value on which to base the filter.

      You can type into the field above the list of values to filter the list or to specify a value. If one or more values are selected, then those items are used in the filter. Otherwise, whatever you type into the field is used by the filter.

    3. In the space between the two selection boxes, select the operator to use for the filter criteria statement, such as equals, not equals, greater than, or less than.

    4. Review the filter criteria statement in the Preview box to ensure that it is as intended. If you need to make changes, edit your selections made above.

    5. Do one of the following:

      • If the filter criteria statement is finished, click OK. The Filter Wizard uses the statement in the Preview box (you do not have to click Apply in this case).
      • To create a compound filter, click Apply to move the current criteria statement into the Filter box. Then, repeat Steps a-d to create another criteria statement. When the next statement is complete, click AND or OR to join it to the prior statement.

    6. To save the filter, click the disk icon next to the Apply box.

    7. In the File name field, type a name for the filter.
    8. In the Description field, type a description of what the filter does.
    9. Click Save.
    10. In the Filter Wizard dialog, click OK.