0
votes

I will try to explain my problem as simple as I can.

I would like to have a crosstab in my report for the questions/answers of a questionnaire. Rows for the questions, columns for the answers and in every cell the sum of the answers.

However, every question has its own group of answer and I would like something like

                       Very     So an So  Don't Ask
How happy are you?      10          9        1        
                      Love it      Nah    It's ok
Do you like rain?       1           3        1

The number represent how many people answered Very or Love it or..you get the point.

What I need is to know if this is possible and if anyone can point out some guidelines to do that!Thank you in advance!

EDIT: (hope this helps) I have a FeedbackT table, and the AnswerT that contains some anwers that don't concern me right now.The AnswerT table is connected with the Answer2T table (I know, it's a mess) and this table is connected with the ActualAnswerT which contains the answers (very low, low, medium...) and another table QuestionQroupT that contains some info about the group that the answers belong to.

The ActualAnswerT contains as many rows as the people who have taken a questionnaire. If 5 people answered a questionnaire, for Question 'A' I could have 3 'Low', 2 'High' from AnswerGroup1, for Question 'B' I could have 1 'No', 3 'Yes', 1 'I don't know' from AnswerGroup2 and so on..

1
If you have limited amount of possible answers (eg 3), then it is better (and simpler) to use 'normal' report and aggregates (of formulas) for result display.Arvo
If you have your questions stored with the group type and each group type has its own headers defined then you can use Group Expert to format your report. Other alternative could be to use Sub-Reports. But nothing can be said without looking at the source data structure.haraman
@Arvo I know and I already did that but I was asked to customize itStamatia Ch
@haraman The questions are not qrouped in any way. The answers may be. I don't know if your suggestion will work with the answers but I will give it a try and let you know.Stamatia Ch
It may be achievable via answer grouping but again depends on your database organization. If you need any help further, edit your question and include your table structure along with relationships of related tables and columns.haraman

1 Answers

0
votes

If you use a union query in the order of question, answer1, answer2, answer3 then you'd have a consistent virtual table you can create a cross tab from.