Great than value/less than other value

F

Francesca

I am trying to create a criteria formula in a query that will find values of
a particular field that are greater than 5 and less than 10 among values
between 1 and 20.
I have run out of ideas and there appears to be no help for me!!
 
K

KARL DEWEY

<5 and <10

Francesca said:
I am trying to create a criteria formula in a query that will find values of
a particular field that are greater than 5 and less than 10 among values
between 1 and 20.
I have run out of ideas and there appears to be no help for me!!
Click to expand...
 
D

Duane Hookom

5 And <10
works for me. What results did you get and what did you expect to get?

Could you share the SQL view of your query?
 
F

Francesca

Embarassed - Poor old slow computer has decided to make >5 And <10 work now.
Thank you for your help.
 
Top