Entering Criteria in Filters

When you enter criteria, you can use all the numbers and letters that you can normally use in the field. In addition, you can use special symbols to further filter the results.

Important
Filtering using the Quick Filter works a bit differently than using the Advanced Filter. The Quick Filter criteria is by default always case insensitive and a * is added to the end of a search criteria. This means that using the Quick Filter, a search criteria defined as Gab will return records containing Gab, gab, Gabriella, etc. If you want to use the Quick Filter for an exact match, enter the search expression in single quotation marks. For example, in the CRONUS International company, on the Customer page, enter a Quick Filter on the Name field as *'@se', which will return the records Selangorian, Meersen, Slubrevik Senger, Beef House, and Hotel Pferdesee. If you enter 'se' only the record Beef House** will be returned.

Important

Filtering using the Quick Filter works a bit differently than using the Advanced Filter. The Quick Filter criteria is by default always case insensitive and a * is added to the end of a search criteria. This means that using the Quick Filter, a search criteria defined as Gab will return records containing Gab, gab, Gabriella, etc. If you want to use the Quick Filter for an exact match, enter the search expression in single quotation marks. For example, in the CRONUS International company, on the Customer page, enter a Quick Filter on the Name field as '@*se*', which will return the records Selangorian, Meersen, Slubrevik Senger, Beef House, and Hotel Pferdesee. If you enter '*se' only the record Beef House will be returned.

Symbols

The following tables show the symbols which can be used in filters.

(..) Interval

Sample Expression	Records Displayed
1100..2100	Numbers 1100 through 2100
..2500	Up to and including 2500
..12 31 00	Dates up to and including 12 31 00
P8..	Information for accounting period 8 and thereafter
..23	From the beginning date until 23-current month-current year 23:59:59
23..	From 23-current month-current year 0:00:00 until the end of time
22..23	From 22-current month-current year 0:00:00 until 23-current month-current year 23:59:59

(|) Either/or

Sample Expression	Records Displayed
1200\|1300	Numbers with 1200 or 1300

(<>) Not equal to

Sample Expression	Records Displayed
<>0	All numbers except 0 The SQL Server Option allows you to combine this symbol with a wild card expression. For example, <>A* meaning not equal to any text that starts with A.

(>) Greater than

Sample Expression	Records Displayed
>1200	Numbers greater than 1200

(>=) Greater than or equal to

Sample Expression	Records Displayed
>=1200	Numbers greater than or equal to 1200

(<) Less than

Sample Expression	Records Displayed
<1200	Numbers less than 1200

(<=) Less than or equal to

Sample Expression	Records Displayed
<=1200	Numbers less than or equal to 1200

(*) An indefinite number of unknown characters

Sample Expression	Records Displayed
Co	Text that contains "Co"
*Co	Text that ends with "Co"
Co*	Text that begins with "Co"

(?) One unknown character

Sample Expression	Records Displayed
Hans?n	Text such as Hansen or Hanson

Combined format expressions

Sample Expression	Records Displayed
5999\|8100..8490	Include any records with the number 5999 or a number from the interval 8100 through 8490.
..1299\|1400..	Include records with a number less than or equal to 1299 or a number equal to 1400 or greater (all numbers except 1300 through 1399).
>50&<100	Include records with numbers that are greater than 50 and less than 100 (numbers 51 through 99).