Design approach for Survey Report (1 Viewer)

Bechert

Registered User.
Local time
Today, 20:57
Joined
Apr 11, 2003
Messages
59
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
 

JHB

Have been here a while
Local time
Today, 21:57
Joined
Jun 17, 2012
Messages
7,732
It depend a little how your data are organized, but can't you use a sum query grouped by questions and choices, picked out in the date range?
Do the percent calculation in the report.
To help you further we need some sample data, (Excel sheet or MS-Access database, zip it).
 

Bechert

Registered User.
Local time
Today, 20:57
Joined
Apr 11, 2003
Messages
59
JBH,

The survey information is stored in one table.
SurveyDate
Q1 Number (long integer)
Q2 Number
Q3 Number
.
Q10 number

Each of the 10 questions (Q1 to Q10) is formatted on the form as a group control with 5 possible values: 1 = excellent, 2 = good, 3 = fair, etc.

A select query to get all the surveys for a date range would look like this, with each survey on it's own row (Date and responses for the 10 questions on a survey). There may be multiple surveys on the same date.

11/1/2014 2 1 4 2 2 1 2 3 4 1
11/2/2014 1 3 4 3 1 3 3 2 3 5
...

I want the report to have the 10 questions running down the left side and
"Excellent" "Good" "Fair", etc. across the top. For example, 10% of surveys for question 1 selected "Excellent" 30% for "good", etc.

Hope that helps.
Bill
 

Bechert

Registered User.
Local time
Today, 20:57
Joined
Apr 11, 2003
Messages
59
JHB,

this is the table design

TableKey (autonumber)
SurveyDate
Q1 Number (long integer)
Q2 Number
Q3 Number
.
Q10 number

This is the survey content in the table
1 11/1/2014 2 1 4 2 2 1 2 3 4 1
2 11/2/2014 1 3 4 3 1 3 3 2 3 5

Bill
 

JHB

Have been here a while
Local time
Today, 21:57
Joined
Jun 17, 2012
Messages
7,732
Sorry, I'll not spend my time creating a table and input some sample data, then I think you are able do it by a few click.
Good luck with your project.
 

Users who are viewing this thread

Top Bottom