NZ not returning 0 values

  • Thread starter Thread starter imfromwisconsin
  • Start date Start date
I

imfromwisconsin

Can someone please tell me what I'm doing wrong on this? I think it's
one of those days...

I have a distinct list [ReasonList].[Reason] that contains a list of
words found in [Reasons].[Reason]. I'm trying to show the entire list
from [ReasonList].[Reason] and the total found in [Reasons].[Reason]
for a specific date range and if the value is null, then to show a 0.

The query works great in finding the results when the value is not
null, but I can't get it to display the 0 for those that are null.

Thanks in advance for your help!

-Ryan



SELECT ReasonList.REASON AS Reason, NZ(Count([Reasons].[REASON]),0) AS
Total
FROM ReasonList LEFT JOIN Reasons ON ReasonList.REASON =
Reasons.REASON
GROUP BY ReasonList.REASON, Reasons.DATE
HAVING (((Reasons.DATE) Between [Enter From Date:] And [Enter To
Date:]));
 
This is perfect; thanks for clarifying the declarations for date/time
as well. I agree that I should change it t to clean up the table.

I really appreciate your help on this, Ken!

-Ryan
 
Back
Top