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.