Filter Examples

A filter expression is as follows:

TABLE --> FIELD --> COMPARISON = VALUE

Consider the following example:

• LTRIM([Client Partners].[Number]) starts with 'AS'

This returns all partners whose Staff No. begins with 'AS'. That is, in a file containing staff AS, ASB and ASDF, who are all partners, data concerning each of them will be displayed.

To limit the results to exact matches, check the maximum length for the FIELD you are using and fill the field with spaces.

• LTRIM([Client Partners].[Number]) starts with 'AS '  

Two spaces are filled in after 'AS' to complete the 4 character length allowed in the Staff No. field. Only information concerning partner 'AS' will be displayed. Information for 'ASB' and 'ASDF' will be filtered out.

Multiple conditions can be used with and (&) and or (|) syntax.

Character fields need quotes around the value. Numeric fields do not.