Filtering Records

Mouse Tracks uses a very powerful filter form to allow you to quickly view a subset of data. The filter form allows you to filter up to 5 fields for the underlying recordset.  The filter will return records that match all of the criteria selected.

Field

When the filter form first loads it will suggest the fields to be filtered based upon the report, graph or list within Mouse Tracks that you are currently viewing.

You can change the field that you are filtering on by selecting the drop-down menu for the field. You will only see the fields listed that are contained in the recordset's underlying table(s).

Comparison

You can choose the comparison operator for each field that you wish to filter. The valid comparisons are as follows.

Operator	Description	Valid Filtering Data
*	Wild Card Match	Any data type (for dates and numeric values the = operator is subsituted)
=	Equals (Exact Match)	Any data type
<	Less than	Any data type
>	Greater than	Any data type
<>	Not Equal (Excludes Exact Match)	Any data type
Between	Greater than value 1 and Less than value 2	Any data type (requires 'And' operator)
Is Null	Field contains data	N/A
Is Not Null	Field does not contain data	N/A

Mouse Tracks will force you to enter valid filtering data based upon the data type for the field selected (e.g., you cannot filter a numeric field using an alpha-numeric value).