Summarizing Grouped Data

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I have a report which shows responses to survey questions, grouped by survey
number. What I would like to do is get the average response value for each
survey question. The report would look something like this:

Survey #1
Question 1 Response
Question 2 Response
Question 3 Response

Survey #2
Question 1 Response
Question 2 Response
Question 4 Response

Survey #3
Question 1 Response
Question 2 Response
Question 3 Response
Report Footer

Question 1 Avg(Response)
Question 2 Avg(Response)
Question 3 Avg(Response)
Question 4 Avg(Response)

I know how to create the grouping to show the survey number group with the
individual questions and responses for each survey. What I can't figure out
is how to create the report footer that summarizes (averages) the response
value for each survey question.

Does anyone have any ideas?

Thanks,

Keith
 
You need to create a subreport based on a totals query to place in your main
report footer section.
 
Back
Top