need syntax help - wrong number of arguments in expression

[Guest]

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)

TANKS so much - Newbee

 

[Guest]

you missing the other iif inside your iif e.g

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, true, 99999999)))

and the 99999999 or the true are not in place, you have to get rid of one of
them

 

[John Vinson]

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)

TANKS so much - Newbee

I think you want to use Switch() rather than Iif() here - IIF takes
only a TRUE or FALSE branch and you have multiple.

John W. Vinson[MVP]