need syntax help -wrong number of arguments in expression 1

[Rousseau10]

iif([eeloca] In ('AMRL','ECON','LUMB','SCIL','TWIS'), 20050301, [eeloca] In ('BOAS','BUHG','JBHT','LBLK'), 20050401, [eeloca] In ('CARD','FRON','AFTY','STHF'), 20050501, true, 99999999)

Tank U!!

I was the first American Soldier to put a basketball hoop up in Iraq, only to have it stolen by a soldier from different camp. Newbee - Adam

 

[PHV]

IIf([eeloca] In ('AMRL','ECON','LUMB','SCIL','TWIS'), 20050301, IIf([eeloca] In ('BOAS','BUHG','JBHT','LBLK'), 20050401, IIf([eeloca] In ('CARD','FRON','AFTY','STHF'), 20050501, 99999999)))


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Rousseau10]

I knew that)&^)(*&!!!! what was i tinking?
Sue per tanx!

I was the first American Soldier to put a basketball hoop up in Iraq, only to have it stolen by a soldier from different camp. Newbee - Adam