Count query but needs to display 0

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query COunt 1
Count qery but needs to display 0 3
multi-value field 1
Making stuff visable or hiden 1
Dispay first 2 letter of post code 2
Use a report to count the # records >0 in Access 2003 2
Nested select query if count > 0 otherwise select all 1
display sales by month 3

Back
Top