IIf Statement

[Guest]

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

 

[Guest]

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,

 

[Guest]

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

many thanx
jkb66