Query filter problem

[Unicon]

Dear All,

I have a query like this (attached) I want to filter value like greater than 7% or less than 15%. I tried a lot but not success.

Please advise.
http://www.access-programmers.co.uk/forums/newthread.php?do=newthread&f=8

 

[namliam]

Have you tried doing the filter on the unformated information?

Between 0.07 and 0.15

Also no need to use the Format function, if you Right click on the Bar above your Field line, you then can select properties and set the format there. keeping it a 'real number' vs using the format which changes your data into Text causing you these headaches your having now.

 

[Unicon]

Thanks namliam,

Still not getting you.

Please advise.

 

[namliam]

OK, step by step.
The query you have
- remove the Format(
- Remove the , "Percent")
- Add to the criteria: Between 0.07 and 0.15

That should make your query work