Duplicate Records with Subreports

  • Thread starter Thread starter Jesse
  • Start date Start date
J

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.
 
Jesse said:
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.
Click to expand...


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.
 
Back
Top