By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,454 Members | 2,629 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,454 IT Pros & Developers. It's quick & easy.

Holy Smokes 21000 pages of report!

P: n/a
I am writing this very simple report and everything looks fine... until
i do a page preview where my supposedly 3-pager balloons into 21K
pages!!! What is wrong??? In the design view, things are perfect but
apparently not. Help!

IQ

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Information Queen wrote:
I am writing this very simple report and everything looks fine... until
i do a page preview where my supposedly 3-pager balloons into 21K
pages!!! What is wrong??? In the design view, things are perfect but
apparently not. Help!

IQ

This is almost always related to an join problem. I've had it often when
I added a table to a query and forgot to join it.
judy
Nov 13 '05 #2

P: n/a
Information Queen,
Check the query that supplies information to the report. I suspect you have
neglected a join somewhere and are getting a Cartesian Product of your
results.

"Information Queen" <tz****@yahoo.com> wrote in message
news:10**********************@f14g2000cwb.googlegr oups.com...
I am writing this very simple report and everything looks fine... until
i do a page preview where my supposedly 3-pager balloons into 21K
pages!!! What is wrong??? In the design view, things are perfect but
apparently not. Help!

IQ

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.