RE: Parameter query/subreport mess
- From: ken <ken@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 6 Apr 2005 09:55:03 -0700
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
"Kathy" wrote:
> 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!
.
- References:
- Parameter query/subreport mess
- From: Kathy
- Parameter query/subreport mess
- Prev by Date: Cannot access reports
- Next by Date: RE: EXPRESSION EQUATION
- Previous by thread: Parameter query/subreport mess
- Next by thread: Errors in Reports
- Index(es):
Relevant Pages
|
