sql - How to return a boolean value for multiple ranges of numbers? -


i trying use iif function create dummy variable in make table query in access '13 , running problems on how construct ranges.

essentially, have 3 columns of categorical data in table numbers ranging 1 through 9 correspond data. want return boolean if values of 3 columns between 4 , 9.

this have tried , returns column of true values, know not case. nonmetro:

iif((4>=[beale versions together]![1983 rural-urban continuum code]<=9)  , (4>=[beale versions together]![1993 rural-urban continuum code]<=9) , (4>=[beale versions together]![2003 rural-urban continuum code]<=9),1,0) 

you can use logic expression:

codesare4to9: [beale versions together]![1983 rural-urban continuum code] between 4 , 9  ,  [beale versions together]![1993 rural-urban continuum code] between 4 , 9  ,  [beale versions together]![2003 rural-urban continuum code] between 4 , 9  

Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -