Iif issues with syntax

[datachick]

PLEASE LOOK AT MY FORMATTING....SOMETHING IS OFF AND I KEEP GETTING SYNTAX ERROR.






IIf(([Table1]![ID]="01M20022") or (Mid([PRODUCT],4,1) = "Q" and [Table1]![Date < #3/1/2015#) ,"HIS",
IIf([Table1]![Field1] In ("CCS20016","CCS20016") or (Mid([PRODUCT],4,1) = "C" and [Table1]![Date < #3/1/2015#) or
(Mid([PRODUCT],4,1) = "F" and [Table1]![Date < #3/1/2015#) ,"CHIP",
IIf([Table1]![ID] In ("GFD20017","TGF20017","CAD20017","20017") or
(Mid([PRODUCT],4,1) = "A" and [Table1]![Date < #3/1/2015#) ,"PRA",
IIf([Table1]![ID] In ("ERR20036","NMA220036","HES20036"),"PPD",
IIf([Table1]![ID] ="JRS20026","ERAt",
IIf([Table1]![ID]="MRA20024","COM","Unknown"))))))

[John_G]

The "in" operator you are using in lines 2, 4 and 6 is only valid in SQL, not in standard VBA as you have it.

[datachick]

Thanks for your assistance.