Multiple, Independent IIf Statements in One Expression

Chi Is Current
Chi Is Current used Ask the Experts™
Looking for a way to write multiple, INDEPENDENT iif statements in one expression (in a text box).
Example: IIf(Field1 = x, "1", "2") OR IIf(Field2 = x, "3", "4")  OR IIf(Field3 = x, "5", "6")...

Comparing 3 different and unrelated fields.
All three statements could be true, in which case the result would look like: 135

Heading for dreamtime now; imagining a better solution out there.
Thank you all in advance.
Will return in AM.

Health ~ Jacob
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You could concatenate the multiple iifs like so:

IIf(Field1 = x, "1", "2") & IIf(Field2 = x, "3", "4")  & IIf(Field3 = x, "5", "6")


Nothing like elegant simplicity.

Thank you ~ Jacob

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial