Extra Pages

[Mark Jackson]

Hello,

My report has 13 pages of the same thing and I can't figure out why. I have
my report set to letter landscape 9.875 x 5.95 with .25 margin for header,
footer, left, and right. I notice if I remove the source control from the
report I have just one page. As soon as I put the source control back I get
13 pages. When I create a new report that is blank and add the source
control I get 13 pages. Does anyone have any idea what I can do to fix this
problem? Thanks in advance.
Mark

 

[Damian S]

Hi Mark,

You will get 13 pages of the same thing if your query is returning 13 rows
of data and you haven't grouped your report , eg: have a Company grouping
with a header and put the company details in there, then list their invoices
in the details section.

Hope this helps.

Damian.

 

[Mark Jackson]

Thanks for your reply. I am new to access. Can you explain in more detail
how I can correct this problem? I really appreciate your help.

Mark