how do i use > and < in a querry

[Guest]

how can i use the greater than or less than symbols in a query so that i can
find a certain range of numbers?

 

[Roger Carlson]

Use the Between function instead:
Ex.
Between 5 And 10
Between #1/1/2006# And #5/1/2006#

The Between function is inclusive, meaning the values in the function are
included in the results.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Duane Hookom]

Open the query in Design View and find the Criteria row under the
field/column where you want to set the filter. Enter something like

<30
or

Date()

or
<="A"
or
Between Date()-30 And Date()

 

[fredg]

how can i use the greater than or less than symbols in a query so that i can
find a certain range of numbers?

To find values between 5 and 10 using < and >
Where YourTable.NumberField > 4 and YourTable.Numberfield <11

To find values between 5 and 9
Where YourTable.NumberField >=5 and YourTable.Numberfield <10

To find values between 6 and 10
Where YourTable.NumberField >5 and YourTable.Numberfield <=10

Of course, to find values between 5 and 10 inclusive, you could simply
use:
Where YourTable.NumberField Between 5 and 10