Query BETWEEN formula giving syntax error (1 Viewer)

[Randy]

This works
IIf([accountnum] Between "60000000" And "60499999","Material","Overhead") AS Assignment

This does not

IIf([accountnum] Between "60000000" And "60499999" OR Between "60510001" and "60809999","Material","Overhead") AS Assignment

Second formula gives me a Missing Operator Syntax Error message. not sure what I am doing wrong.

 

[pbaldy]

Shot in the dark, but try

IIf([accountnum] Between "60000000" And "60499999" OR [accountnum] Between "60510001" and "60809999","Material","Overhead") AS Assignment

 

[BitsOfBytes]

You could just use a nested IIf statement and do each true individually. Then set the false part as the same "Overhead".

IIf([accountnum] Between "60000000" And "60499999", "Material, IIf([accountnum] Between "60510001" and "60809999","Material","Overhead")) AS Assignment

 

[arnelgp]

i am not sure if the IIF function can process Between statement, it will not give error though.

 

[pbaldy]

i am not sure if the IIF function can process Between statement, it will not give error though.

OP says it works without the Or.