Subreports repeating on a page

[MGregory]

I have built a report with subreports. The subreports for the same record
repeat 2, 3 even 4 times in the printout. What is causing this?

 

[Marshall Barton]

I have built a report with subreports. The subreports for the same record
repeat 2, 3 even 4 times in the printout. What is causing this?

That's almost always because the main report's record source
query joins to the same table as the subreport's record
source. Change the main report's record source so it only
retrieves data that belongs in the main report, This is
usually easiest if you work with the query alone so the
report doesn't confuse things.

 

[MGregory]

I had one query that gathered info from the various tables, and the main
report and the subreport were all based on that one query.

So, I created a new query that just gathered the info for the main report,
but now none of the subreports are showing.

Should each subreport be built on a separate query? Is that where I'm going
wrong? Thanks.

 

[Marshall Barton]

I had one query that gathered info from the various tables, and the main
report and the subreport were all based on that one query.

So, I created a new query that just gathered the info for the main report,
but now none of the subreports are showing.

Should each subreport be built on a separate query? Is that where I'm going
wrong?

That depends on what the subreport are supposed to display,
but it is common for different subreports to use different
record source queries.

Check the subreport controls' LinkMaster/Child properties.
They may have been cleared or maybe you forgot to include
the linking field(s) in some of the queries.