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.
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.