Help with MS Access Report: Repost

[Kaur]

Hi,


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.

 

[Duane Hookom]

Did you try the reports I suggested in my reply in your previous thread of
the same question?