What am I doing wrong?

[Lori]

I have two queries/reports that work perfectly as individuals however I need
one report with the information for both. I created a third report and added
the other two as subreports.

So Far so Good, the fields in both of the original reports are the same, the
data comes from different places.

Now here's the problem. I've used the Req# and Project# (which are the two
fields both reports filter by) as the link between the main report and the
two subreports. The data comes out beautifully but 17 times! My 2 page report
is 34 pages. How do I stop the duplication?

 

[Ofer Cohen]

If the main report is bounded to a table that has few records, and the sub
report is placed in the detail section, the sub report will repeat it self as
many time as the amount of records.

If that the case, you can move the sub report to the report header or footer
so it will print only once.

 

[Lori]

Okay, this worked perfect, I moved one subreport into the header and one into
the footer (when I tried to move both into one place it put the header or
footer on a separate page), so here's the new problem. When both of the
subreports were in the detail section I was able to sum the totals from the
two reports in the Report footer, now when I try to view the report it asks
me for the values for the fields and returns a blank. How do I sum between
header and footer? is it even possible?