interview report

[Guest]

I need to create an interview report that should reflect questions and answers.
But, the problem is that some questions have subquestions.

The esiest way is to combine the main questions with subquestions and
answers with subanswers showing them together.

Another, more accurate, way would be to show questions, subquestions,
answers, and if any subanswers.

So, please advise whether it's possible to create a report grouping by main
questions and by subquestions showing subquestion group only if it's not
Null. Then in the details part of the report to assign values from answers
programmatically (VB) - if the subquestion is not Null then subquestion
answer; if it's Null then main answer.

Please, advise as don't have time for an experiment as I need to do it in a
couple of days.

Thanks in advance.

 

[Duane Hookom]

Do you have a table structure you would like to share? Is your table
structure normalized?

 

[Guest]

Thanks a lot, Duane.
The tables is going to be like this if I mix questions and subquestions
(there is no problem to implement):

Question Table:
QuestCode QuestText
Q1_1 Text1_1
Q1_2 Text1_2
...........

Interview Table (here I could make key on Department and QuestCode):
ID (Key AutoNumber) Department QuestCode Answer
1 AC Q1_1
Answer1_1
2 AC Q1_2
Answer1_2
........

However, in the case of the separation the questions and subquestions I see
it like this:

Question Table
ID (Key - AutoNumber) QuestCode QuestText SubQuestCode SubQuestText
1 Q1_1 Text1_1
2 Q1_2 Text1_2 SQ1_2_1
S1_2_1Text
3 Q1_2 Text1_2 SQ1_2_2
S1_2_2Text
4 Q1_2 Text1_2 SQ1_2_3
S1_2_3Text
.......

Interview Table:
ID Department QuestCode Answer SubQuestCode SubAnswer
1 AC Q1_1 Answer1_1
2 AC Q1_2 SQ1_2_1
S1_2_1Answer
3 AC Q1_2 SQ1_2_2
S1_2_2Answer
4 AC Q1_2 SQ1_2_3
S1_2_3Answer
........

 

[Duane Hookom]

It's a bit difficult to understand your data due to wrapping. I would add a
field to the question table that identifies the parent of the question if
there is one.