I have a form that collects student survey responses to about 75 questions. Each response is a value between 1 and 5. What is the best way to get averages, counts, and other statistics from the table?
I have tried a group by in my query but am unsure what field to group by. I want to find out what percentage of respondants answered 1 (or 2 or 3 or 4 or 5) to each of the questions. I have not been able to figure out how to organize a query to get this data. All respondants are anonymous, so a cross tab query doesn't seem to make sense either. Should I give up and export the data table to excel?
