Filter Builder

 

The Filter Builder assists you in creating a FIND filter.  A FIND filter will narrow down the number of records displayed in the FIND window.

 

For any given column, you can limit the results displayed using a variety of operators, such as “greater than” and “less than”.  The available operators are:

 

            >          Greater than     

            <          Less than

            >=        Greater than or equal to

            <=        Less than or equal to

            =          Equal to

            <>        Not equal to

 

For text fields (such as description, class, dates, etc.), you also can use an operator named “LIKE”.

 

The “LIKE” operator will return any row that includes the text entered.  For example, entering “LIKE green” in the description column will return all descriptions that contain the word “green”.  It is not case sensitive.

 

Comparisons can be “strung together” using AND and OR.

 

Using OR will return more records.

 

Using AND will return fewer records.

 

If you use up all the available filter columns, pulling down “AND or “OR” at the end of the row will open up another set of filter logic columns.

You can also use the filter to find a range of values. 

 

To find all “Description” values starting with the letter “A”:

 

 

A NOTE ON NUMERIC VALUES

 

Numeric values are displayed in a rounded format, with typically only two or three decimals displayed.  If rounding has occurred, you will not have much success if you try to use a filter on a numeric value, such as

 

            = 35.0

 

Instead, use

 

> 34.99 and < 35.01