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 |
smaller than or equal to a specified value |
<= |
<=30 |
greater than a specified value |
> |
>20 |
greater than or equal to a specified value |
>= |
>=30 |
A range of information |
... |
1/1/2000 ... 1/1/2002 |