need syntax help - wrong number of arguments in expression

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Newbee Adam - 14 Apr 2005 21:33 GMT

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

Reply to this Message

Ofer - 14 Apr 2005 21:41 GMT

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

Reply to this Message

John Vinson - 14 Apr 2005 23:28 GMT

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

Reply to this Message