EXPRESSION

MEANING

>250

Numbers greater than 250

<10,000

Numbers less than 10,0000

="Smith"

Specific names ending with Smith

<>"Green"

Is not equal to Green

>#01/01/99#

All records beginning Jan. 1, 1999

>=300

Is greater than or equal to 300

<=100

Is less than or equal to 100

Between 10 And 20

Number from 10-20 inclusive

like "S*"

Items beginning with letter s

Is null

Selects empty fields

Or ("France" or "Germany")

Selects records from France and Germany

And (The word and is not specifically used)

Selects two or more search fields