use 0 for null value in count query

[hyperionfall]

I have this:



SELECT Count([TETHERlogHISTORY].[DATEOFRETERM]) AS [CountOfDATEOFRETERM]
FROM [TETHERlogHISTORY]
GROUP BY DateDiff("d",[DATEOFRETERM],Now())
HAVING (((DateDiff("d",[DATEOFRETERM],Now()))<7));

I need the query to show 0 if it returns a null value.

i tried this:

SELECT Nz(Count([TETHERlogHISTORY].[DATEOFRETERM]), 0) AS [CountOfDATEOFRETERM]
FROM [TETHERlogHISTORY]
GROUP BY DateDiff("d",[DATEOFRETERM],Now())
HAVING (((DateDiff("d",[DATEOFRETERM],Now()))<7));

but it did not work.

any ideas?

thanks

[hyperionfall]

nevermind i got it...

SELECT Nz(Count([TETHERlogHISTORY].[DATEOFRETERM]), 0) AS [CountOfDATEOFRETERM]
FROM [TETHERlogHISTORY]
GROUP BY DateDiff("d",[DATEOFRETERM],Now())
HAVING (((DateDiff("d",[DATEOFRETERM],Now()))<7));


GROUP BY DateDiff("d",[DATEOFRETERM],Now())
this was the culprit...removed the grouping (cant remember why it was there in the first place...bingo it worked fine now

any idea why the grouping would cause that?