By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,970 Members | 1,669 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,970 IT Pros & Developers. It's quick & easy.

Help with MS Access Report: Repost

P: n/a

I am trying to create a crosstab type of report without using crosstab
query. The report captures several survey questions and for each survey

questions there are multiple choices that users responded to. There are
three tables for this particular report that will be used. LkupQuestion
has all the questions, LkupAnswerChoices has all the anwerChoices. The
third table contains the association of questions and anwer choices
with the response rate. The third table looks like this.

Question Answer Choice Response
1 Agree 70%
1 Disagree 20%
1 Strongly Agree 10%
2 Good 30%
2 Poor 20%
2 Do not Know 50%
3 Satisfied 30%
3 Not Satisfied 20%
and so on.
Basically I am trying to create a report from above table that will
look some thing like this
displaying question text, multiple reponse text and the response rate:
Text for Question 1 Agree Disagree Strongly Agree
70% 20% 10%
Text for Question 2 Good Poor Don't know
30% 20% 50%

Text for Question 3 Satisfied Notsatisfied
20% 30%
I can not create a crosstab query as each question has different
answers choices to select from which result in having a total of more
than 70 answer choices.
Any help will be appreciated.

Nov 30 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.