Hello Group,
I need to create a customer satisfaction survey summary report.
Each question is a group control with 6 check box choices. There are 10 questions.
A question looks like this on the form.
Question 1 excellent good fair poor very poor N/A
The values for the control group are excellent = 1, good = 2, fair = 3 etc.
Each table record will have the survey date and the control group value for each question.
The summary report will be for all surveys within a date range.
The summary report would look like this:
excellent good fair poor very poor N/A
Question 1 11% 19% 35% 30% 4% 0%
Question 2 1% 45% 30% 20% 2% 3%
.
.
The 11% excellent calculation is the total Excellent responses divided by the number of responses to questions 1.
How do I create the summary report for all the surveys completed for the period?
Thanks for your help.
Bill
I need to create a customer satisfaction survey summary report.
Each question is a group control with 6 check box choices. There are 10 questions.
A question looks like this on the form.
Question 1 excellent good fair poor very poor N/A
The values for the control group are excellent = 1, good = 2, fair = 3 etc.
Each table record will have the survey date and the control group value for each question.
The summary report will be for all surveys within a date range.
The summary report would look like this:
excellent good fair poor very poor N/A
Question 1 11% 19% 35% 30% 4% 0%
Question 2 1% 45% 30% 20% 2% 3%
.
.
The 11% excellent calculation is the total Excellent responses divided by the number of responses to questions 1.
How do I create the summary report for all the surveys completed for the period?
Thanks for your help.
Bill