N
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
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