Query COunt

[Simon]

I am trying to do a count what count to see how many brochures have
not been sent with the following query


SELECT tblBrochure.BrochureSent, Count(tblBrochure.BrochureRequestID)
AS CountOfBrochureRequestID
FROM tblBrochure
GROUP BY tblBrochure.BrochureSent
HAVING (((tblBrochure.BrochureSent)=False));




If all the brochures have been sent then the query dispalys nothing,
how do i get it to dispay 0

Thanks

 

[John Vinson]

I am trying to do a count what count to see how many brochures have
not been sent with the following query

Use WHERE rather than HAVING:

SELECT Count(*)
AS CountOfBrochureRequestID
FROM tblBrochure
WHERE (((tblBrochure.BrochureSent)=False));


John W. Vinson[MVP]