G
Guest
I have a table showing the results of a questionnaire, with one field for
each question, say Q1, Q2, Q3 etc. Say there are up to five possible answers
for each question, A1, A2, A3, A4 and A5. I want to be able to count how
many respondents answered A1 to question 1, how many answered A2 to question
1 etc.
Previously, I have used the following expression in the report or group
footer: =Sum(Abs([Q1]=â€A1â€)) and then copied and adjusted it.
However, I now have a larger questionnaire with 25 questions with say five
possible answers for each. This means I would have to do 125 expressions.
Is there an easier / quicker way to do this?
each question, say Q1, Q2, Q3 etc. Say there are up to five possible answers
for each question, A1, A2, A3, A4 and A5. I want to be able to count how
many respondents answered A1 to question 1, how many answered A2 to question
1 etc.
Previously, I have used the following expression in the report or group
footer: =Sum(Abs([Q1]=â€A1â€)) and then copied and adjusted it.
However, I now have a larger questionnaire with 25 questions with say five
possible answers for each. This means I would have to do 125 expressions.
Is there an easier / quicker way to do this?