IIf statement

[towsie]

Hi,

When he IIf statement below is run the following error occurs,

Runtime Error '3061': Too few parameters. Expected 1.

IIf((Customer = 'Shell Uk Ltd') and (Participator = 'SHELL UK LIMITED'), (Template_Name = 'Crude - SUKO - ' & Crude.F5), (Template_Name = 'Crude - Third Party - ' & Crude.F5)))

Thanks

Towsie

[QVeen72]

Hi,

Try This :

[CODE=sql]IIf(((Customer = 'Shell Uk Ltd') and (Participator = 'SHELL UK LIMITED')), ( 'Crude - SUKO - ' & Crude.F5), ( 'Crude - Third Party - ' & Crude.F5)) As Template_Name[/CODE]

Regards
Veena

[Killer42]

Just for future reference, towsie, IIF isn't a statement. It's a function. They are not the same thing.