Filter Button

The Filter button, which you can access from the Select Records dialog or the print-time Record Picker data entry control, appears in each of the table's column headers. You can use it to filter the record set based on criteria that you enter for a single field.

To access the Filter button, point to the header of the column that you want to filter by until the icon appears. Click the icon to display a list of the available filter options.

The list contains all of the values that are currently entered in records for the selected field and one or more of the following default values:

(All): Displays all records. Any previous filter option that you selected for this column is removed.
(Custom): Opens the Custom AutoFilter dialog, where you can create a filter for the column by using a complex expression with up to two conditional statements.
(Blanks): Displays only records that have no value in that column.

Select the filter option that you want. The record set is refreshed and displays only those records that meet the specified criteria. Click to select the check boxes next to the records that you want to print.

After you filter the contents of one column, you can refine your filter further by selecting Filter button options on other columns.

Related Topics