Why printing more than 1 page?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a report that captures information from some forms and queries.
Strangely, it is previewing the same page 4 times for a client, 6 for
another, and just one for a few. I have not been able to trace the problem
and the printed out pages are exactly the same. What am I missing?

Thanks,

Frodo.
 
View the report's record source in data sheet view to see how many records
are present. Does this look correct? Do you have any subreports in your main
report?
 
Hey Duane,

Sorry it took so long to reply.

My underlying query produces the right amount of information...but yes, as
you mentinoned, there are subreports in the report...4 as a matter of fact.
How does this affect it, and what can I do?

Thanks,

Frodo.
 
I expect that you have a level of detail in the main report that should be
removed. For instance, if your main report was based on the Orders Table and
the subreport was based on the OrderDetails table, you would NOT include the
OrderDetails in the main report.
 
Hey Duane,

Thanks so much! I did have a level in the detail that was also in the
subreports.

Have a blast of a week!

Frodo.
 
Back
Top