Great than value/less than other value

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!!
 
G

Guest

<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?
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sql query needed urgent 4
query counting issue 4
Greater than, less than, AS WELL AS value=0 5
Iif Query 5
Nested Iif Formula Question 3
Query criteria "Greater than value/Less than value"? 1
Query that returns values greater than zero 2
Passing > or < from a form 2

Top