SQL Statement in Access RRS feed

  • Question

  • User-1230161102 posted


    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

    Tuesday, July 31, 2012 10:05 PM


All replies