Hi
I have a survey of 10 questions stored in MS-Access table Table1 with 11 columns
PersonName Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10
All questions are multipe choice questions. For some questions the user should choose Yes or NO. However he has to choose amonge 5 answers from 1 to 5
I need to write sql statement the qet me how many Yes or Nos are given to each of question of the first type. And it should gives me for the rest of questions how many choose 1, 2, 3, 4 or 5
We can consider Yes as 1 and NO as 2
for example I expect te result of the query to be someting looks like
Question No (1) (2) (3) (4) (5)
Q1 5 6
Q2 7 3 12 22 1
How to write sql statement qives me that
I appreciate your help
I have a survey of 10 questions stored in MS-Access table Table1 with 11 columns
PersonName Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10
All questions are multipe choice questions. For some questions the user should choose Yes or NO. However he has to choose amonge 5 answers from 1 to 5
I need to write sql statement the qet me how many Yes or Nos are given to each of question of the first type. And it should gives me for the rest of questions how many choose 1, 2, 3, 4 or 5
We can consider Yes as 1 and NO as 2
for example I expect te result of the query to be someting looks like
Question No (1) (2) (3) (4) (5)
Q1 5 6
Q2 7 3 12 22 1
How to write sql statement qives me that
I appreciate your help