Counting including 0

Charmed7

Registered User.
Local time
Today, 11:07
Joined
Jul 23, 2004
Messages
53
I need to run a query counting how many policies a client cancelled. But I need the query to include zeros. Is this possible?

Here's my SQL Statement currently.

SELECT DISTINCTROW Pqry_CancelledPolicy01.Number, Pqry_CancelledPolicy01.Name, Pqry_CancelledPolicy01.POLICY_STATUS, Count(Pqry_CancelledPolicy01.Number) AS CountOfNumber
FROM Pqry_CancelledPolicy01
GROUP BY Pqry_CancelledPolicy01.Number, Pqry_CancelledPolicy01.Name, Pqry_CancelledPolicy01.POLICY_STATUS
ORDER BY Pqry_CancelledPolicy01.Number;


Thank you in advance for the help.
 
Is this not possible? Is there a way to include in the statement to show Is Null fields?
 

Users who are viewing this thread

Back
Top Bottom