Apply Filter

In a grid, the filter drop-down menu to the right of a column name, gives you the ability to define a simple or a custom filter.

Simple

A filter can be setup to display only those records that have a particular value in the column, for example, a unit of equipment, say Truck1:

Note that you could also have selected to only show those records with blank or non-blank values in the column.

Custom

To define a more complex filter, select (Custom) from the drop-down box. Filter conditions can be set In the Custom AutoFilter dialog. The values you can enter will depend on the column you have selected.

(And and Or) logical operators and (Equals, Like, Greater than, Less than, etc.) comparison operators may be used to define a complex filter condition.

Note that not all column filters support the Like comparison operator.

The following wildcards may be used when specifying values:

Wildcard	Description	Example	Returns
_	represents any single character	AAA_	AAA3, AAA4
%	represents any series of characters	AAA%	AAA301, AAA-B2