Getting count data from multiple columns into single report

[macdoggy]

Hi, I have a table of questionnaire data with multiple columns of multiple choice questions (you can pick from 5 different answers) and several columns of true/false questions.

I am trying to write a report showing what percentage of people chose each answer for each question. I have written a nested report and each subreport comes from a different query I made based on the table and one of the questions. This shows the basic data I need, but seems really convoluted and I'm wondering if anyone knows how to write a report like this without so many queries and subreports behind it??

Also, I am using an older version of Access. I think I have 2002 or 2003 at work and 2000 or 1999 at home (if this makes a difference).

Thanks for your help!

M

 

[dhookom]

You might want to look at "At Your Survey" found at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

If you can't change your table structure, you can create a union query that creates a normalized view of your data for reporting.

Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[macdoggy]

Thank you. This really helped!!!