I'm trying to count answers to a series of multiple questions but can't get the SQL query to work properly. I have a table as follows: Code: Q1 | Q2 | Q3 Agree | Disagree | Strongly Agree Disagre | Agree | Agree Agree | Strongly Agree | Disagree ... I would like to output totals for each type of response for each question in a (query) table like: Code: Answer | Q1Count | Q2Count | Q3Count Agree | 2 | 3 | 5 Disagree | 1 | 5 | 3 Strongly Agree | 4 | 3 | 2 ... I've been trying a query like this: Code: SELECT AnswersTable.Q1, Count(AnswersTable.Q1) AS Q1Count, Count(AnswersTable.Q2) AS Q2Count, Count(AnswersTable.Q3) AS Q3Count FROM AnswersTable GROUP BY AnswersTable.Q1 ORDER BY AnswersTable.Q1 DESC; However, the output from this query is in the wrong order. While the counts for Q1 match the GROUP BY unique values, the other counts are disordered. Any tips on how to get the right output? Cheers.