IIF Statement with OR criteria

[McArthurGDM]

Hi,

I'd like to set up the criteria on one of the fields in a query as an If statement.

The If statement will reference a form, as such:



IIF(Form.Control = "March", "January" OR "February" OR "March", "")

Basically, I want it to notice what month the control has, and to set the criteria to display all months prior and up to that one...

but this way is not working - how do you set this up?

[ssanfu]

The IIF() function has 3 parts: IIF(Condition, ValueIfTrue, ValueIfFalse)

You have to explicitly test each condition. It would look something like:

IIF(ControlName = "March" OR ControlName = "January" OR ControlName ="February" OR ControlName ="March", ValueIfTrue, ValueIfFalse)

Without knowing what you are trying to accomplish, this might not be the best method. But I hope I have answered your immediate question.

[McArthurGDM]

Correct, I am trying to get it so that the value if true portion has an OR condition... but I don't know if I can do that.

[McArthurGDM]

I think I can get around this issue with numbers, actually.

Create a new field designating Jan = 1, Feb = 2, etc... etc...

Then saying something like IIF(Form.Control = 4, Number <= 4, "") or whatever....

[ssanfu]

The condition has to evaluate to TRUE or FALSE. The "VALUE IF TRUE" returns a value... or you can have a nested IIF()

This returns "Q1" or "Q2"

IIF( ControlName = "January" OR ControlName ="February" OR ControlName ="March", "Q1", IIF( ControlName = "April" OR ControlName ="May" OR ControlName ="June", "Q2",  "Unknown"))

Would you explain what you are trying to do? This doesn't make sense to me.

value if true portion has an OR condition

[ssanfu]

IIF(Form.Control = 4, Number <= 4, "")

This will return TRUE if the "Form.Control" has 1, 2, 3 or 4 . Is that what you want?

[McArthurGDM]

I don't know why, but...

When I create my query...which has a field called PeriodCalc which contains numbers 1,2,3,4,... etc.



I set up

IIF(Form.Control = 4, [PeriodCalc]<=4, 0)

NOTHING shows up in the query results!


Why?

[ssanfu]

IIF(Form.Control = 4, [PeriodCalc]<=4, 0)

This should return TRUE (or -1) or Zero.

What is "Form.Control"?????

Please post the SQL of your query.

[Xipooo]

I would highly recommend you use the SWITCH function instead.

http://www.techonthenet.com/access/f...ced/switch.php