Filter Tab

Any Selection

Selected, a record need only match one of the conditions.

Clear, a record must match all filter conditions.

Field Name

Enter or use the drop-down to select the fields in the data file for filtering.

Op

The Operator. When combined with search criteria, the operator defines a condition that a record must satisfy to be selected. Operators can be typed or selected from the drop-down. If this is blank and you enter selection criteria, the default operator is = (equal to). See Operator Meanings and Rules below.

Criteria

Values that the operator in the Op field are applied to. To search for records that have no entry for a field, use the operator = and leave the Criteria field blank. For some fields, criteria can be selected from a drop-down list.

You can use the ? and * wildcard characters. For alpha-numeric fields, upper and lower case are ignored.

For Date fields, all the numeric operators except +- can be used. To search for a date in relation to the System Date, enter DATE, followed by + or -, then the number of days before or after the System Date to search for. For example, DATE-7 would be one week prior to the System Date.

Toolbar

Expand Toolbar (Ctrl+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Insert (F4)

Insert an item at the selected line.

Move (Shift+Up) (Shift+ Down)

Select an item and move it higher or lower on the list.

Delete (F3)

Delete the selected item.

Clear Filter (Ctrl+F3)

Clear the selected filter.

Buttons

Save (F9)

Save and exit the window.

Cancel (Esc)

Discard changes and exit the window.