Expression Builder IIF() Question

[wtucker]

Hey everyone,

I'm stuck on this expression. It's a nested IF function. Everything looks right, and the Microsoft website seems to confirm it, but it's just not working.
Is there a better way to do nested IF or IFS?

=IIf([Network]="Trilogy","A004",IIf([Network]="PHCS","A003","N/A"))

Thank you!

[Bulzie]

When you say not working does it not return the results you want or gives an error message?

[wtucker]

After clicking ok in the Expression Builder, it will reset to a blank logical statement.

[June7]

Cannot replicate issue.

Switch() and Choose() can be used in place of nested IIf() (not available to Calculated type field in table).

=Switch([Network]="Trilogy","A004", [Network]="PHCS","A003", True,"N/A")

However, probably would not resolve this issue.

[Bulzie]

wtucker, not sure what that means, create a new query with your table(or query) and add this to a column(add Network field as well to make sure it is working) and run it, does it work?

x: IIf([Network]="Trilogy","A004",IIf([Network]="PHCS","A003","N/A"))

[wtucker]

Yeah this was a weird one. I tried to save the database and Access crashed. Upon reloading, the logic worked. Go figure.

Thanks to everyone that contributed!

[Missinglinq]

I couldn't replicate the issue, either, but why use the Expression Builder instead of simply placing the syntax directly in the Control Source Property?

Linq ;0)>

[Bulzie]

My suggestion was just to test to see if you got the results you wanted.