Hi,

I am using Ultra Dev 4.0 and Access 2000.
I have created a SQL request under Access and it works fine but when I try to use it under Ultra Dev It didn't work.
Here is the SQL request :
SELECT Courses2001.Clef, Pilotes.Nom, Sum(Nz([Courses2001]![POINTSD1],0)) AS TotalD1, Sum(Nz([Courses2001]![POINTSD2]-30,0)) AS TotalD2, Sum(Nz([Courses2001]![POINTSD1],0)+Nz([Courses2001]![POINTSD2]-30,0)) AS TotalD1D2, Sum((Nz([Courses2001]![PENALITED1],0))+(Nz([Courses2001]![PENALITED2],0))) AS TotalPENALITE, (Sum(Nz([Courses2001]![POINTSD1],0)+Nz([Courses2001]![POINTSD2]-30,0)))-(Sum((Nz([Courses2001]![PENALITED1],0))+(Nz([Courses2001]![PENALITED2],0)))) AS TotalGeneral, Count(Courses2001.POINTSD1) AS CompteDePOINTSD1, Count(Courses2001.POINTSD2) AS CompteDePOINTSD2, Count(Courses2001.F) AS CompteDeF
FROM Courses2001 INNER JOIN Pilotes ON Courses2001.Clef = Pilotes.Clef
GROUP BY Courses2001.Clef, Pilotes.Nom
ORDER BY Sum(Nz([Courses2001]![POINTSD1],0)+Nz([Courses2001]![POINTSD2]-30,0)) DESC;

Here is the error in ultra dev
Nz functin not defined in th expression

There is Null values in my database. I have to make Sum between two colums where there is null value, so I have to give zero value for all null value.

Thanks for your help, sorry for my english (I am french...)