M
Missi Sargnet
I have created an evaluation questionnaire with 9 questions for people who
attend classes. Each classes has a unique ID but will have several responses.
Four of the questions have drop down responses of Yes, No or Blank. The
other 5 questions are on a rating scale of 1 to 5. If I create a query for
each question I can use the group by and count to find out my totals (i.e. 5
yes, 4 no, 1 blank) for each question separately. But I cannot figure out how
to join them into a single query so that I can summarize all the questions on
one report? Can this be done without the use of SQL?
attend classes. Each classes has a unique ID but will have several responses.
Four of the questions have drop down responses of Yes, No or Blank. The
other 5 questions are on a rating scale of 1 to 5. If I create a query for
each question I can use the group by and count to find out my totals (i.e. 5
yes, 4 no, 1 blank) for each question separately. But I cannot figure out how
to join them into a single query so that I can summarize all the questions on
one report? Can this be done without the use of SQL?