need syntax help - wrong number of arguments in expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
Click to expand...

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]
 
Back
Top