Filter Condition Dialog Box

When a report requires filtering on a data field, this dialog box is used to allow you to enter your filter condition on that field. The database table name, field name, and the data type, are show in the title bar of the dialog box to help you with your choices.

Possible Filter Conditions

Through the use of the NOT check box and the list box below it, you can create any type of filter condition you like. The possible filter conditions are as follows.

Condition	NOT	Result
Equal To	Unchecked	equal to
Equal To	Checked	is not equal to
Less Than	Unchecked	less than
Less Than	Checked	is greater then or equal to
Greater Than	Unchecked	greater than
Greater Than	Checked	is less then or equal to
In	Unchecked	in
In	Checked	is not in
Between	Unchecked	between
Between	Checked	is not between
Like	Unchecked	like
Like	Checked	is not like

Using Like for case insensitive compares

For text compares that should be compared case insensitive, use the Like operator. For example, if you want to match a field with the values of 'Mike' or 'mike', use the operator Like and enter the text 'mike'.

Using Like for partial matches

If you need to match text that is contained in a field, use the Like operator with the percent sign (%). For example, lets say you want to match all rankings that have the word 'News' at the end. Select the Like operator, then type the text '%news'. This will match any name that ends in the word 'news'. Basically, the percent sign (%) is a wildcard matching character. Percent says to match any characters at that position, or none.

Comparing Dates

Dates in the database are stored in the format of 'YYYY-MM-DD' (e.g, 2005-08-14) and are treated as text fields. This is a standard ISO date format. Dates stored this way will sort and compare properly when treated as text.