Is there anything strange about NZ function?

[Guest]

I can run my query with NZ function from within Access however cannot run it
via OLEDB connection even though its using Jet DB engine.
Here is my query, I tried changing it to not use NZ but nothing seems to
work the same.

SELECT ID, T1 & IIF(NZ(T2,'')='','','--') & T2 & IIF(NZ(T3,'')='','','--') &
T3 AS KWDesc FROM tblKWFlat ORDER BY T1, T2, T3;

Basically I need three columns if not null to be separated by '--'
e.g.
abc
abc--def
abc--def--ghi

Any ideas?

 

[Ken Snell \(MVP\)]

Nz is a VBA function, and probably isn't available to the database that is
running the query that you want to run?

Try this:

SELECT ID, T1 & IIF(T2 Is Null,"",IIf(T2='','','--')) & T2 & IIF(T3 Is
Null,"",IIf(T3='','','--')) & T3 AS KWDesc FROM tblKWFlat ORDER BY T1, T2,
T3;