"Between" Query

[aarellano]

I have a quesry with different account numbers the account numbers are 8 spaces and then 5 digits. for example
' 42000' the las 3 digits can be the same on multiple accounts with for example ' 42350' ' 44350'
I was trying to do an iif statement
iif account between ' 42000' and ' 44320', America, iif account between ' 44000' and ' 45320' America))this work well but I would have to type each number so what I tried was
iif account between ' *000' and ' 320', America) but this does not work, but if I fo a
iif account like '*000', America) this works
a bit confused of why one works and the other does not. And is there a way I could solve this???


Thanks!!!

 

[Remou]

How about:

Val(Right(account,3)) Between 0 And 320

http://lessthandot.com