Count "Zero values"

[bmccabe]

I've been trying to get something working, that seems very simple an
yet despite doing a search on this site (and finding good information
can't seem to pull it together.

I hope I am just missing something simple!

I have a table with multiple choice survey data (a series of question
and sub-questions with multiple respondents) - I have built a query t
count the number of answers for each question and display them in
chart on a report. Essentially this works fine although in some of th
questions there are 0 responses for one of the 5 multiple choice value
- and the chart consistently just omits that value for the give
question rather than show the answer with a count of zero responses a
I would like it to do.

Thought I had the solution (read on this forum) and created a singl
field table for just the allowable responses "1,2,3,4,5" - built a ne
query with a Left Join (to show all values from the "allowabl
responses" table and matches in the resulting query that match) howeve
I still get missing (zero values) in my chart.

Any suggestions on what I could try (please let me know if more detai
is required).

Thank

 

[Michel Walsh]

Hi,



COUNT(*) will count the number of record, COUNT(fieldName) counts the
number of records not having NULL under FieldName. Thus, COUNT(*) -
COUNT(fieldName) counts the number of NULL under fieldName.


Hoping it may help,
Vanderghast, Access MVP