Help building a complex report

N

Nevelyn

I am building a test question database in ACCESS. I have
one main table with an ID, etc and then six other tables
(one for each type of question (matching, multiple
choice, true/false, etc.) as well as one for listing
every time the question was used on a test. The question
is only be in (at most) three of the tables (main, years
used and one matching the type of question it is).

Question 1: Can I bring all of that information together
in one complex query or is it better to combine six
different queries (pairing the tables up)?

Question 2: In developing a report (printout of a random
number of test questions), I want to display different
fields on the report based on the type of question that
is selected (for instance multiple choice will show more
fields on the report than true/false)
Can I make the report changes on the fly - in the report
code somewhere or do I have to generate six different
reports based on the six types of questions?

I hope this makes sense. Please respond with any ideas.
Feel free to email me privately if it's a long response.
 
Top