I tried to remove tables but it kills the report. Now this report has 3 sub
reports in it 2 out of three of the sub reports prints correctly i.e. only
once, just the one sub report is causing me issues of repeating its self on
page 2 of what should be a 1 page report.

"John Spencer" wrote:

Mor Likely you need to remove a table from the query rather than fields.

Of course you can use
SELECT DISTINCT ...

and remove all the fields from the tables that are being used in the sub-report.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Xfree wrote:
Daune,
I am still battling this issue, I have removed fields but I am still
getting the sub-report section printing twice.

Any other ideas?


"Duane Hookom" wrote:

You are somewhat correct. It's more like you have a detail table in your main
report's record source that should not be included.

--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

When you say level of detail are you saying I may have fields in the main
report that should only show up in the sub reports?

"Duane Hookom" wrote:

Usually this suggests you have a level of detail in your main report's Record
Source that should only be in a sub-report.
--
Duane Hookom
Microsoft Access MVP


"Xfree" wrote:

I have a report that contains three sub reports everything is working
correctly as far as the output except the one page report repeats its self on
a second page with all the same info except the header. Is this a setting I
have wrong or a format issue?

Let me know if more info is needed for this issue.

Thanks