use between statement in an iif statement

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Try and use this instead
Like IIf([Forms]![Invtrany info]![Month]=99,"*",[Forms]![Invtrany
info]![Month])
 
If that is supposed to be criteria, you cannot do it that way. You can pass
parameters (values), but NOT operators (between, =, >, etc)

One option would be to use criteria like the following
Between IIF([Forms]![Invtrany info]![Month]=99,1,[Forms]![Invtrany
info]![Month])
And IIF([Forms]![Invtrany info]![Month]=99,12,[Forms]![Invtrany info]![Month])

OR another option if your criteria are not too complex is to use something like this.

(YourField = [Forms]![Invtrany info]![Month] OR [Forms]![Invtrany info]![Month]
= 99)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using OR in IIF statement 6
Iif Statment 7
Current month IIf statement. 3
iif statement 4
IIF Statement 2
IIf Statement in Query Criteria 1
Date Brackets as an IIf statement 3
IIf statement, wildcard to return all records 7

Back
Top