Duplicate Records with Subreports

[Jesse]

I've created a report containing two subforms. They associate all of the
data accurately, but create duplicate pages of the full report. For example,
if my subreport has eight items associated with January, I will run the
report, and get eight copies of the January report. Each report looks as it
should, but I want only one copy of the report. Thanks in advance for any
suggestions.

 

[Marshall Barton]

I've created a report containing two subforms. They associate all of the
data accurately, but create duplicate pages of the full report. For example,
if my subreport has eight items associated with January, I will run the
report, and get eight copies of the January report.

That happend when the main report's record source query
joins the subreport data. It should be better if you drop
the subreport table from the main report's query.