Hi,
I have this long nested query that when I run it it will not return the second 601, "SPC". Code 601 can either be an "EMN or "SPC" depending on the case # and member. Thank you appreciate any help you can provide.
initiated: IIf([tbl_mbrs].[frg_id_cd] in ("401","402"), "YES",IIf([tbl_mbrs].[frg_id_cd] ="601", "EMN",IIf([tbl_mbrs].[frg_id_cd]="601", "SPC",IIf([tbl_mbrs].[frg_id_cd]="602", "Trans", IIf([tbl_mbrs].[frg_id_cd]="603, "Heart",IIf([tbl_mbrs].[frg_id_cd]="604, "SPECIAL"))))))