I've made a survey in Access 2000. A series of forms has the questions on them. To answer each question, the person clicks an option button for "Agree", "Strongly Agree", "Disagree" or "Strongly Disagree". After answering all 80 questions, the person has created a record with 80 fields that have a value of 1 thru 4 representing their answer to each question (or null if they didn't answer a question). An auto-number field is the record key. There is also a field for their department. I want to make a report that lists for each question, how many people answered "Agree", how many answered "Strongly Agree", etc. The report is to be grouped by department. So far I've made 80 append queries to create a table whose key is the auto-number plus the number of the question. It also has the answer-value and unit. From that table I can get a report that sums all departments, but making a query or table to feed a report grouped by department seems like a huge amount of extra work. There's got to be a better way, but I've been buried in this so long I can't see straight. Any suggestions?
Last edited:
