What is wrong with this IFF?

[bburton]

I'm trying to produce a multiple IIf argument. With so much coding in it, I've confused myself. I'm still working on trying to figure it out, but if any of you could figure it out before I do that'd be great. I have 8 possible outcomes from check box results. Only one outcome can be produced into the proper string. Otherwise if nothing is selected, then it'd just be an empty space/null. It is from a unbound Form.

Outcomes:

Missing Window & Missing Door -> Missing window and door.
Non-Op Window & Non-Op Door -> Non-Op window and door.
Non-Op Window & Missing Door -> Non-Op window and missing door.
Missing Window & Non-Op Door -> Missing Window and non-op door.
Missing Window -> Missing window.
Missing Door -> Missing door.
Non-Op Window -> Non-op window.


Non-Op Door -> Non-op door.
Nothing selected -> Null

My latest attempt was:

IIf([Forms]![Checklist]![RSwNO]  And [Forms]![Checklist]![RDrNO],"The rear window switches and door  handles are  non-operational",IIf([Forms]![Checklist]![RSwNO]<>0,"The rear  window switches are non-operational. ") &  IIf([Forms]![Checklist]![RDrNO]<>0,"The rear door handles are  non-operational.")) & IIf([Forms]![Checklist]![RSwMiss] And  [Forms]![Checklist]![RDrMiss],"The rear window switches and the door  handles are missing. ",IIf([Forms]![Checklist]![RSwMiss]<>0,"The  rear window switches are missing. ") &  IIf([Forms]![Checklist]![RDrMiss]<>0,"The rear door handles are  missing.")) & IIf([Forms]![Checklist]![RDrNO] And  [Forms]![Checklist]![RSwMiss],"The rear window switches are missing and  the door handles are non-operational.  ",IIf([Forms]![Checklist]![RDrMiss] And [Forms]![Checklist]![RSwNO],"The  rear window switches are non-operational and the door handles are  missing. ",""))

That nearly worked, however... It would produce some duplicates when one non-op is checked and one missing is checked. Such as:

"The rear door handles are non-operational.The rear window switches are missing. The rear window switches are missing and the door handles are non-operational."

When it should be just "The rear window switches are missing and the door handles are non-operational."

I hope I didn't make this too confusing, I've confused myself with this so many times....

[ssanfu]

This is what I did. Type an immediate IF() statement.

iif(Condition,"Text",False)

Then, where ever there is a FALSE, paste the IF() statement again, for a total of 8 times.

(this is 4 times)

iif(Condition,"Text",iif(Condition,"Text",iif(Condition,"Text",iif(Condition,"Text",False))))

Next, where ever there is the word "Condition", replace it with your test:

iif([Forms]![Checklist]![RSwNO]  And [Forms]![Checklist]![RDrNO],"Text",iif(Condition,"Text",iif(Condition,"Text",iif(Condition,"Text",False))))

And replace "Text" with your text:

iif([Forms]![Checklist]![RSwNO]  And  [Forms]![Checklist]![RDrNO],"The rear window switches and door  handles are  non-operational",iif(Condition,"Text",iif(Condition,"Text",iif(Condition,"Text",False))))

Do this for each of the 8 nested IIF() statements.


--------------------------------------
This is my attempt:

 x = IIf([Forms]![Checklist]![RSwNO] And [Forms]![Checklist]![RDrNO], "The rear window switches and door handles are non-operational", IIf([Forms]![Checklist]![RSwMiss] And [Forms]![Checklist]![RDrMiss], "The rear window switches and the door handles are missing.", IIf([Forms]![Checklist]![RDrNO] And [Forms]![Checklist]![RSwMiss], "The rear window switches are missing and the door handles are non-operational.", IIf([Forms]![Checklist]![RDrMiss] And [Forms]![Checklist]![RSwNO], "The  rear window switches are non-operational and the door handles are missing. ", IIf([Forms]![Checklist]![RSwNO] <> 0, "The rear window switches are non-operational.", IIf([Forms]![Checklist]![RDrNO] <> 0, "The rear door handles are non-operational.", IIf([Forms]![Checklist]![RSwMiss] <> 0, "The rear window switches are missing.", IIf([Forms]![Checklist]![RDrMiss] <> 0, "The rear door handles are missing.", ""))))))))

[bburton]

Thanks a lot, I knew I must have done something wrong... That works great! Also thanks for the little step by step, that made it clear and easier for me to build a nested IIF (properly) lol.