Query criteria "Greater than value/Less than value"?

G

Guest

I want to create a query criteria that displays a value greater than 5 but
less than 10 from a field of numbers between 1 and 20. I have not been able
to find the right formula.
Microsoft Access 2000
 
A

AndreasRoeder

Francesca said:
I want to create a query criteria that displays a value greater than
5 but less than 10 from a field of numbers between 1 and 20. I have
not been able to find the right formula.
Microsoft Access 2000
Click to expand...

HI Francesca,
please ask in the microsoft.public.access newsgroup
 

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

Sumif number is greater than a number but less than another number 2
Make the sum of cells no greater than X 0
Great than value/less than other value 4
change a value based on adding another cell 1
Greater than, less than, AS WELL AS value=0 5
Return value greater than in LOOKUP 3
averaging a range 3
IF statement greater than and less than 8

Top