Apply a Custom Filter

More complicated filters can be set up using the Enter filter criteria dialog. To access, select the (Custom) option in the operators list. The Enter filter criteria for [name of field] dialog is then displayed.

Two types of filter conditions can be set up using this dialog, "And" and "Or". For data to be displayed on a form, it must either match all of the "And" conditions and at least one of the "Or" conditions.

To set up a custom filter:

1. Specify whether the filter conditions are "And" conditions or "Or" conditions by selecting the required option from the Filter based on list.

2. Filter conditions are defined in the row of fields below the Filter based on list. The first field displays the attribute being filtered.

3. In the second field, elect an operator, e.g. "= Equals".

4. In the third field, select a value to filter by.

5. To add a second condition, select the Add. Another row of fields is then added to the form in which a filter condition can be entered as described above. Repeat for each required filter condition.

6. To delete a condition, select it and click Delete.

7. When all the required filter conditions have been set up, click OK. The filter will then be applied to the tab.