Counting non-responses in a survey

[Joe]

I'm using CR to create 5000 survey reports for 450 managers each in their own workgroup. Each report is one page. The client wants to know--for each item--how many NON-RESPONSES there were. I can do a count for responses for how do you count NON-reponses (aka missing data)? One would think it would be as simple as calculating the difference between the total number of respondents in a workgroup and the number of responses. But, the total number of respondents in each workgroup varies. Any suggestions?

Thanks!

 

[Steve R.]

I will assume that each question in the survey has only a certain number of possible check boxes, lets 1 through 5. I also don't know how the data is entered into the computer. So a couple of scenarios present themselves.

If the data is being entered manually, you could have an option at the computer end for the data entry clerk to enter a 0 (zero) or 6 for a non response.

If the data is being scanned into the computer so that there is a readable value, you could use VBA loop through each question to see if there is at least one answer, if not then a value of 0 or 6 could be assigned to that answer as a non-response.

Of course, there is a world of difference between entire forms not being returned and not answering specific questions.