G
Guest
I need help with an iif statement in a query. Basically I have a form that
the person uses to either choose a month or choose all months using option
buttons. The statement reads -- IIf([Forms]![Invtrany
info]![Month]=99,Between 1 And 12,[Forms]![Invtrany info]![Month]). It works
fine if they choose a month, but not when they choose all months (I used 99
for the month number). However, the between statement works fine if it’s not
in the iif statement.
the person uses to either choose a month or choose all months using option
buttons. The statement reads -- IIf([Forms]![Invtrany
info]![Month]=99,Between 1 And 12,[Forms]![Invtrany info]![Month]). It works
fine if they choose a month, but not when they choose all months (I used 99
for the month number). However, the between statement works fine if it’s not
in the iif statement.