IFF statement in microsoft query

[Pepino]

I'd like to use funkcion IIF in microsoft query ODBC database .
I wrote "IIF(resn70='4';0;lqty70*litr35/iscf35/100)"
Bat a message appears "SQL0104-Token = is not valid"
Please help

 

[jorismoerings]

Hi,

The error says SQL0104-Token = is not valid.
The only part where you're using the = sign is creating the error.

Have you tried to double quote instead of single ones, like this: IIF(resn70="4";0;lqty70*litr35/iscf35/100)

 

[Pepino]

Hi Joris,
I tried to use double quote in a couple of times. The same message is still showing "SQL0104-Token = is not valid. Valid tokens :,. "
I'm not so sure if IIF can be used in microsoft query ??? It does not have any other solution that will do the same???

 

[Fazza]

IIF should be fine.

Syntax I'm familiar with has only ever been : IIF(resn70='4',0,lqty70*litr35/iscf35/100)
That is, comma separators between arguments.

Also in case relevant, the '4' is only suitable for a text field. I'm wondering if resn70 is a numeric field?
If so, try IIF(resn70=4,0,lqty70*litr35/iscf35/100)