I have the following query that counts the brochure requests we have
had. It works fine but if we have not had any it does not dispay 0. how
do i make it dispaly 0

SELECT Count(tblBrochure.BrochureRequestID) AS CountOfBrochureRequestID
FROM tblBrochure;




Thanks

That works fine for me with an empty table.

How are you displaying the value? If it's in a text box, might you have
formatting on that blanks 0 values?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Simon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have the following query that counts the brochure requests we have
> had. It works fine but if we have not had any it does not dispay 0. how
> do i make it dispaly 0
>
> SELECT Count(tblBrochure.BrochureRequestID) AS CountOfBrochureRequestID
> FROM tblBrochure;
>
>
>
>
> Thanks
>

Try using the NVL function to tell it to bring a 0 back if there is no
value.example:

SELECT NVL(Count(tblBrochure.BrochureRequestID,O) AS CountOfBrochureRequestID

This works in other query languages, not sure it will work here.

> > FROM tblBrochure;


"Douglas J. Steele" wrote:

> That works fine for me with an empty table.
>
> How are you displaying the value? If it's in a text box, might you have
> formatting on that blanks 0 values?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Simon" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >I have the following query that counts the brochure requests we have
> > had. It works fine but if we have not had any it does not dispay 0. how
> > do i make it dispaly 0
> >
> > SELECT Count(tblBrochure.BrochureRequestID) AS CountOfBrochureRequestID
> > FROM tblBrochure;
> >
> >
> >
> >
> > Thanks
> >
>
>
>