Parameter query/subreport mess

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi! I posted this yesterday and now I can't find it in any of the topics. I
also can't remember what I titled it but I believe it had something to do
with ulcers.

I have a database that is collecting evaluations. I wanted to create a
report that looked for records from a specific course, semester and year.
The query is fine and the results are fine except I was unhappy with the
formatting (i.e., an individual respondent's comments for all questions are
in one glob, then the next, etc.). I wanted each type of comment (a single
field) to be printed/displayed in a single section. So I came up with the
idea of using subreports that would gather the data from the original
parameter query.

The problem is that each subreport now requires entry of the criteria every
time. That's 24 separate data entries to get each report. I created a form
for the entry, thinking this would solve the problem but noooooo...

Any help would be greatly appreciated!
 
The way i did something similar is to make one query for the main report, and
a seperate query for the subreport. then when editing the main report, you
can link the two queries based on whatever the appropriate join conditions
would be.

ken
 
Back
Top