Another question on a survey database

[seamusnboo]

Ok, I need further help with that my survey database. I wonder if somebody could help me figure this out. So, I have this survey database with questions for visitors of a certain park. I have several Yes or No questions. I created queries that will count how many Yeses or Nos I have for each question. But a problem is happening. Sometimes certain questions are left blank, with no answer. My query is showing the blank answers with a count of zero, even if there are more then one blank answers. How can I get the query to count the blanks? Or, can I fill the blank answers with the word "Blank" automatically somehow?

Thanks

 

[seamusnboo]

The way I'm couting is. I created a query from the original table. I activated the Totals button. On the first field of the query, I selected the survey field I want to be counted and on Total, I selected Group By. On the second query field I selected the same survey field and on Total, I selected Count. This way the query will show me all the different kind of responses and how many of each I have. In my case I only have yeses, nos and blanks, so the query shows me how many yeses or nos I have, but on blanks it counts as zero, even though I have more than 1 blank answers on my table.

I'm not really sure how I'm supposed to use the code you suggested. I'm sorry if I'm asking something obvious, but I don't have much experience with Access.

Thanks