Using arithmetic operators to narrow your search

In a find request, you can make your search more specific by using arithmetic signs (operators) to find values relative to a value you specify.

  To find values that are   Use this operator   Example
Less than < "<250" finds all values less than 250

Greater than > ">250" finds all values greater than 250

Less than or equal to <= "<=250" finds 250 and all values less than 250

Greater than or equal to >= ">=250" finds 250 and all values greater than 250

An exact match = "=Dan" finds Dan but not Daniel

Not equal to <> "<>7" finds all values except 7

Related topic

  Finding records with a find request

 
Table of contents Index