Count query for questionnaire

[Nedlog]

Hi

I have a table in access that holds information on a survey. The table
has an ID for each questionnaire then 5 columns indicating each
person's top 5 preferences from the 12 options as answered on the
questionnaire.

ID 1st 2nd 3rd 4th 5th
----------------------------------------------------------
Q1 Option6 Option3 Option8 Option11 Option9
Q2 Option2 Option9 Option4 Option5 Option12
Q3 Option7 Option6 Option1 Option4 Option3
.........

How can I create a query to count the answers in a summarised view as
follows:


Answer 1st 2nd 3rd 4th 5th
---------------------------------------------------------------
Option1
Option2
Option3
Option4
Option5
Option6
Option7
Option8
Option9
Option10
Option11
Option12

Thanks in advance for any help with this,
D

 

[Duane Hookom]

You might need to first normalize your table with a union query so you end
up with 3 fields: ID, Option, and Choice. Then create a union query based on
the union query.