Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

QuickReport / General Concept Problem

0 views
Skip to first unread message

spam...@googlemail.com

unread,
Feb 17, 2008, 8:15:28 AM2/17/08
to
I am trying to produce a report which is an exam. The data structure
seemed fairly simple with only two table (in access) designed as
follows, where* denotes a primary key:

TQuestion (QuestionID*, QuestionNum...etc)
TQuesionPart (QuestionID*, Number*, Letter*, Question, Answer...etc)

To display these on a quickreport i need the structure

QuestionID1
..................................................
Letter1 Numeral1
Numeral2
Numeral3
Letter2 Numeral1
Letter3 Numeral1


QuestionID2
..................................................
Letter1 Numeral1
Letter1 Numeral1

etc.etc.

So my report structure is currently:

Title
GroupHead1 //Question info grouped by QuestionID
GroupHead2 //QuestionPart Ino Grouped by... QuestionID?
Detail // Letters + Numerals of this question
GroupFoot1
GroupFoot2
PageFoot

However i can only get this to preview for either:
a) a single question, with all parts or
b) each question with only a single part each
depending on which query i set to 'master' of the report.

The two queries are fairly simple so i don't think they need to be
posted. i think there is something fundamentally wrong with my
concept. ideally i could go back and restructure the data, but this
project is too far along at this stage.

Sorry for all this detail, i have spent several hours on this problem
and would love some advice =)

thanks in advance.

0 new messages