I have a database setup to collect results of surveys on seminars. There are different seminars, and 9 different items to track. The 9 items are in groups of 3 - first group reponses are Excellent, Very Good, Good, Fair and Poor; 2nd group are Very Likely, Somewhat Likely and Not Likely, 3rd group are Agree, Neutral and Disagree. I have set up forms to collect results, and that works fine. What I need to do next is to be able to tabulate the results by seminar and rating, and create reports and charts from that.
I am finding it had to summarize the results by rating -- I think this should be fairly simple, but having trouble getting to the right results. Crosstab queries do not work; I cannot group by rating. I tried to create a summary query to count the ratings, but need to create an individual query for each of the 9 items, and then combine them into one query, which I think is much too cumbersome. Does anyone know of any easier way to accomplish this?
Attached is sample of my data - first tab shows the table that holds the survey results. 2nd tab is a sample of what I am trying to accomplish. I would eventually want to use those results to create graphs and reports by seminar or for all seminars.