using two ANDs in a Query
Posted on 2011-09-29
I would like to specify multiple query using two ANDs using Select Query. I am basing a report which has to pick two ranges within the same field, ie.
range from 60 to 69 and from 90 to 99.
I have tried the following in the criteria box.
(between 60 AND 69) and (between 90 AND 99)....no luck
I have tried permutations of the above but to no avail.
Grateful to know if it can be done?