I am putting this code into an access query and the last two iif statements give me a #Error result. So it's not recognizing anything for "VA", "FHA", "RISK".
Code:
Investor2: IIf([MIS.CD] In ('B','L','M','N','S','W'),"PRIVATE",IIf([MIS.CD]
In ('C','V'),"FHLMC",IIf([MIS.CD] In ('F','Y'),"FNMA",IIf([MIS.CD]
In ('H','P','R') And [LOAN.TYPE] In ('3','4'),"VA",IIf([MIS.CD]
In ('H','P','R') And [LOAN.TYPE] In ('2'),"FHA", "RISK")))))