Access 2010 Compound Conditional

[Doug LaPedes]

I have code IIF(test,true, false)where true or false can be another IIF condition, The true or false for that conditional can also be another IIF. All conditions are seperated by "," and the expression ends with the corect number of ")" (one for each IIF). I get an error missing "bar" or "bracket" invalid syntax. I have tried another format using a ")" at the end of each secondary IIF and still get an error. The statement has 8 IIFs.

IIF([a]= [c], "True", IIF([b] = [d],"true",IIF([x] = [y],"true",IIF(........

I have also tried
IIF({a] = [c], IIF([d] = [e], "true", "False")
IIF([a] = [d], IIF([g] = [h], "true", "false")).....(four more IIFs follow.

Suggestions?

[Doug LaPedes]

I think I found the problem. There was an action for each true and false for each condition EXCEPT for the last condition; I was missing a "False" action for this condition.

[Mihail]

As an advice:
When create nested IIFs create it separately. Then, for bottom to top, nest its.
Example:

IIF([a]= [c], "True",)
IIF([b] = [d],"true",)
IIF([x] = [y],"true",LastResultIfFalse)

Now, cut the last IIF and paste into the false part to upper one:

IIF([a]= [c], "True",)
IIF([b] = [d],"true",IIF([x] = [y],"true",LastResultIfFalse))

Repeat the operation:

IIF([a]= [c], "True",IIF([b] = [d],"true",IIF([x] = [y],"true",LastResultIfFalse)))

If this nested IIFs must be in a Query, use VBA editor until you obtain the code then paste this code into the query.

[NeoPa]

Doug, "What's the problem with this formula?" type questions don't work too well without the whole and complete formula being included ;-)