IIf Statement

jkb66 · Jan 4, 2006

Good Afternoon;

Please look at this IIf statement - I keep getting comma errors!

IIf(cable.FGLAND like 'H*',(mid(cable.FGLAND), 2),cable.FGLAND) AS
CONNECT_TYPE,

thanx
jkb66

Ofer · Jan 5, 2006

Try this, the open brackets should be after the mid and not before

IIf(cable.FGLAND like 'H*',mid(cable.FGLAND, 2),cable.FGLAND) AS
CONNECT_TYPE,

jkb66 · Jan 5, 2006

Thank you Ofer, that appears to have solved the problem!

many thanx
jkb66