Is it possible to do mutiple Between Ands in a Query?

[jmriddic]

Hi,

Is it possible to specify multiple Between Ands in a query. What I am trying to do is return a list of zipcodes that are in our state but out side the region we support. I know what the min and max values for the zipcodes are for the state so here is what I did. I used one between..and to specify the values from the min for the state to the zipcode digit onless than the min for the region and I did another between.. and form one digit higher than the max for our region to the max zipcode for the state. Now I did these on seperate criteria lines. It only return the values below our ranges but no values above our range which I do know exist. What am I doing wrong?

 

[tjs206]

Try this on the same criteria line:

(Between <minzipcode> and <maxzipcode>) or (Between <zipcode> and <zipcode>)

See if that works. I think this is what you are looking for, if not, post a reply.

 

[Jack Cowley]

If you put the Between And's one above the other in the criteria lines (this is equal to an Or) you should get the data you want.

hth,
Jack

 

[jmriddic]

Hi jack,

I tried that in the beginning. It might be because the zipcode is a text field. Might that be causing it?

 

[Jack Cowley]

Then try this:

Between "12345" And "23456"
Between "34567" And "56789"

hth,
Jack