MS Access reports

[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. Basically
I am trying to create a report 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]

Could you share your table structure? I'm not sure how you expect us to help
you without understanding your data.

 

[Kaur]

Hi,
There are three tables for this particular report that are being 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
which is pulling the report.


QuestionID Answer ChoiceID Response
1 1 50%
1 2 30%
2 3 20%
2 4 10%
and so on.
Thanks

 

[Duane Hookom]

There are several sample crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. The crosstab.mdb has a
report where the column headings might differ.

 

[Kaur]

Thanks ever so much!! It saved me a lot of time figuring out how to
generate a report like this.