Help with report with sorted group and then counts on fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report of responses to a survey which I need to sort and group by
department, with one page of the report for each department. Within each
department page, I have a number of questions in which the respondent needed
to grade various topics on a 0-5 scale. I need to report on the number of
respondents for each department for each question that rated topic 0, 1, 2, 3
, 4 or 5.
I'm new to Access, and know how to sort and group the records by department
on the report, but I can't seem to get the counts for each topic and ratings
to work. What combination of functions is necessary to do something like
this? Any help for this newbie will be greatly appreciated! TIA!
 
Questionnaire response databases are commonly set up with an incorrect (i.e.
not normalised) table structure. If you have it right then it's very simple
to get the kind of thing you're after, while if your structure is wrong then
it's way harder.

Details on how to do it right are here...
http://support.microsoft.com/default.aspx?scid=kb;en-us;101675

If that's not how you have it set up then you should modify your table
structure.
 
Rob -

Thanks for your help. You were right, I need to restructure my database.
The link is exactly what I needed.
 
Back
Top