nz not working in A200?

[Jesper F]

I'm getting an error running this in A2000. Works fine in A2002.
It says that the Nz function is undefined. Can't it work in A2000?

SELECT
tblDataTempVars.varID,
tblDataTempVars.varname,
Min(IIF(IsNumeric(Nz([svar],'')),
CDbl([svar]), Null)) As MinSvar,
Max(IIF(IsNumeric(Nz([svar],'')),
CDbl([svar]), Null)) As MaxSvar,
Avg(IIF(IsNumeric(Nz([svar],'')),
CDbl([svar]), Null)) As AvgSvar,
Count([svar]) As CountSvar,
StDev(IIf(IsNumeric(Nz([Svar],'')),
CDbl([Svar]), Null)) As StDevSvar
FROM tblDataTempVars
LEFT JOIN qryDataTemp ON tblDataTempVars.varID = qryDataTemp.varID
GROUP BY tblDataTempVars.varID, tblDataTempVars.varname
ORDER BY tblDataTempVars.varID

Thanks.

Jesper

 

[Duane Hookom]

Nz() has been around for a long time. Have you checked your references in a
module?

 

[Jesper F]

Nz() has been around for a long time. Have you checked your references in

a module?

Got it working after a decompile. References were ok.
Thanks.


Jesper