Previous Topic

Next Topic

Book Contents

Book Index

Finding ranges of information

In text, number, date, time and datetime fields you can search for ranges of information.

To find

Use this operator

Example

smaller than a specified value

<

<20
<1/1/2003

smaller than or equal to a specified value

<=

<=30
<=1/2/2003

greater than a specified value

>

>20
>1/1/1900

greater than or equal to a specified value

>=

>=30
>=2/3/2003

A range of information

...

1/1/2000 ... 1/1/2002

See Also

Finding data

Finding text (strings)

Finding numbers

Finding dates and times

Finding data in related fields

Using multiple find criteria

Excluding records from your found set

Extending the found set

Reducing the found set