Filtering Rules tab

Specify Filtering Rules tab (Linked Database Wizard)

Allows you to specify filtering rules to include/exclude records when printing.

Field to Compare

Select the field you want to base the filter on.

Comparison

Select the type of comparison you want to do on the selected field. The choices are:

Equal To

This comparison equates to true when the field is exactly the same as the comparison value.

Not Equal To

This comparison equates to true when the field is not exactly the same as the comparison value.

Less Than

This comparison equates to true when the field is less than the comparison value.

Greater Than

This comparison equates to true when the field is greater than the comparison value.

This comparison equates to true when the field is similar to the comparison value. There are two special wildcard characters used with LIKE, % and _. % represents zero or more wildcard characters and _ represents exactly one wildcard character.

For example:

Name LIKE 'Pa_' is true when Name is Pam, Pat, Pan, Paw, etc.

Name LIKE 'To%' is true when Name is Tom, Tommy, Top, To, Tomali, etc.

Name LIKE '%a%' is true when Name is cat, dad, daddy, ash or any word than contains the letter a.

Enter the value to compare it to

Enter the value you want to compare the selected field to.

Add Condition button

Click this to add the condition.

Tip:

•	You can add an AND or an OR (below) then repeat the process to filter on multiple fields and/or multiple comparisons.

Add AND button

Click this to add an AND conditional after a comparison.

Add OR button

Click this to add an OR conditional after a comparison.

Clear Filter button

Click this to clear the filter and use all records in the database.

Filter

Displays the filter.