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 some special symbols or mathematical expressions. Here are the available formats:



Sample Expression

Records Displayed


Equal to


Number 377




Those with the BLUE code, for example, the BLUE warehouse code




A datetime: from 22-current month-current year 0:00:00 to 22-current month-current year 22:59:59



22 10

An exact datetime: 22-01-01 10:00:00




Numbers 1100 through 2100




Up to and including 2500



..12 31 00

Dates up to and including 12 31 00




Information for accounting period 8 and thereafter




From the beginning of time until 23-current month-current year 23:59:59




From 23-current month-current year 0:00:00 until the end of time




From 22-current month-current year 0:00:00 until 23-current month-current year 23:59:59




Those with number 1200 or 1300




Numbers that are less than 2000 and greater than 1000.

The & sign cannot be used by itself with numbers because no record can have two numbers.


Not equal to


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 texts that start with A.


Greater than


Numbers greater than 1200


Greater than or equal to


Numbers greater than or equal to 1200


Less than


Numbers less than 1200


Less than or equal to


Numbers less than or equal to 1200


An indefinite number of unknown characters


Texts that contain "Co"




Texts that end with "Co"




Texts that begin with "Co"


One unknown character


Texts such as Hansen or Hanson


Calculate before rest


Those with number 30 or with a number from 10 through 20 (the result of the calculation within the parentheses)


Ignore case (either uppercase or lowercase allowed)


Texts such as LOCATION, location or Location

You can also combine the various format expressions:


Include any records with the number 5999 or a number from the interval 8100 through 8490.


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).


Include records with numbers that are greater than 50 and less than 100 (numbers 51 through 99).


Texts containing both C and D.


Texts containing co, CO, Co, cO, such as cot, cope and incorporated.

CO, cO, Co or co must be present, followed by at least one character, but there can be an indefinite number of characters before and after these, and case is unimportant.


It is important that you enter only meaningful filters. For example, it is possible to specify an interval that does not exist, and the program cannot check this for you. In order to enter meaningful filters, you must know the sorting rules followed by this program.

Related Topics