Great than value/less than other value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
<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...
 
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?
 
Embarassed - Poor old slow computer has decided to make >5 And <10 work now.
Thank you for your help.
 
Back
Top