Query Range Instructions
There are two types of range queries; inclusive (><) and exclusive (<>).An inclusive range
query will display the results included in the entered parameters. Forexample, to search for
all records between and including 06/01/00 and 06/28/00, you would enter><060100:062800.
An exclusive range query will provide results which exclude the parameters entered. For
instance, to search for all records other than those between and including 06/01/00 and
06/28/00, you would enter <>060100:062800. When using dates in these types of queries,
you must enter the year.
This works for any range in a field, not just dates, i.e., you can query for truck numbers
300 to 315 by doing ><300:315, however it will also return subs such as 305T0, etc.
|