Help with SQL null value

[kevinh2320]

I have the following query in my MS Access db. The problem I'm having is when no AmtDue (amount due) has been received the query just returns as blank. I want is for the query to return as 0 in cases when no AmtDue has been received. Here's what I have so far. Any suggestions on how to modify this query to achieve that or, a new query would be appreciated.

SELECT Sum([SalesTbl].AmtDue) AS SumOfAmtDue, [SalesTbl].AmtReceived
FROM 906kTbl
GROUP BY [SalesTbl].AmtReceived
HAVING ((([SalesTbl].AmtReceived)="YES"));

 

[xenou]

In Access you can use the Nz() function for this, so:

SELECT Sum(Nz([SalesTbl].AmtDue, 0)) AS SumOfAmtDue, [SalesTbl].AmtReceived
FROM 906kTbl
GROUP BY [SalesTbl].AmtReceived
HAVING ((([SalesTbl].AmtReceived)="YES"));

 

[kevinh2320]

Thanks that worked!