Replace Nulls with Zeros

[thawstone]

In the following simplified query, in some months(MonthOf) there were no warranties so I have a null field for AcceptedWarranties:

SELECT qryWarranty.MonthOf, qryWarranty.AcceptedWarranties
FROM qryWarranty;

In order to make my Warranty Trends graph work I need 0s. Other postings show the following statement should get the results I need:

SELECT ISNULL(AcceptedWarranties, 0 ) FROM qryWarranty

But no matter how I try to work this into the original code, the compiler finds reason to reject it.
Can someone please put me out of my misery.

 

[madefemere]

Hello,

You can use Nz function as :

SELECT qryWarranty.MonthOf, nz(qryWarranty.AcceptedWarranties,0)as WarrantiesAccepted
FROM qryWarranty;

Good continuation.

 

[thawstone]

Thank you kindly. I'd tried the Nz function without the ,0) to no avail. I don't know why I torture myself so needlessly when there are so many people like yourself willing to help.