not show the value zero

[azhar2006]

Hello all
Beautiful and happy day for all


I have a query in which fields pay off the debt to the creditor and the convicted
When I put the process output does not show the value zero
Why ?

[azhar2006]

SELECT Sum(Query1.Expr3) AS SumOfExpr3, Sum(Query1.Expr5) AS SumOfExpr5, InvoiceDate.HAS, InvoiceDate.amount, tblCompanies.COMNAME, Sum(CCur(Nz([Expr3],0)-Nz([Amount],0))) AS Expr8
FROM tblCompanies INNER JOIN (InvoiceDate INNER JOIN Query1 ON InvoiceDate.OrderDateID = Query1.OrderDateID) ON tblCompanies.IDCOM = InvoiceDate.IDCOM
GROUP BY InvoiceDate.HAS, InvoiceDate.amount, tblCompanies.COMNAME;

Without the benefit of
The result does not show zero

[AnanthakrishnanK]

Try with Nz function separately. I think, it is the solution.