I'm a newbie to this forum and Access XP.
Situation: I need to analyze a survey that contains 22 multiple choice questions.
Problem: The 22 questions each have 3 possible choices. I need to calculate how many people chose "A", "B" or "C" for each question. I then need to express the choices in a percentile.
MY (time consuming) Solution: Make 22 separate queries, 1 for each question. Use the results on the report.
End Result: The resulting calculation would be something like this on a generated report (I know how to do the report, but not the query for it) -
How fast do you drive? A) Very fast - 20%
B) Not very fast - 10%
C) Slowly - 70%
Question: Is my solution wrong? Can it be made easier? Can I make ONE query that gives me the result for all 22 questions that can be put on the report? Should i be doing a crosstab query instead?
Thanks for the help!!!
Situation: I need to analyze a survey that contains 22 multiple choice questions.
Problem: The 22 questions each have 3 possible choices. I need to calculate how many people chose "A", "B" or "C" for each question. I then need to express the choices in a percentile.
MY (time consuming) Solution: Make 22 separate queries, 1 for each question. Use the results on the report.
End Result: The resulting calculation would be something like this on a generated report (I know how to do the report, but not the query for it) -
How fast do you drive? A) Very fast - 20%
B) Not very fast - 10%
C) Slowly - 70%
Question: Is my solution wrong? Can it be made easier? Can I make ONE query that gives me the result for all 22 questions that can be put on the report? Should i be doing a crosstab query instead?
Thanks for the help!!!