Nested iif sum statement in report....

[topdesk123]

I thought I knew how to do this, but apparently I've forgotten.

=(IIf([status2]="Failure","Failure",Null Or IIf([status2]="Success","Success",Null Or IIf([status2]="Illegal","Illegal",Null))))

What am I forgetting?

TIA!
topdesk

 

[lespaul]

iif(condition, value if true, iif(condition, value if true, value if false))

How about something like this though:

iif([status2] in ("Failure", "Success", "Illegal"), status2, "")



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[topdesk123]

You are my hero Leslie! Thanks so much!! Have a great day!

 

[lespaul]

thanks, you too!

glad it helped

leslie