Access 2003 PrintPreview too many pages

  • Thread starter Thread starter BobFromPlymouth
  • Start date Start date
B

BobFromPlymouth

I have a form with "yes" "no" answers to questions.
After 10 records are entered for example I have another form to total up the
results. When I go to print preview I see the totals correctly, but the
navigation at the bottom shows 10 identical pages instead of 1 .
Help...
 
Are there actually 10 identical pages or is this just the display at the
bottom?
Have you checked the report's record source to identify your issue?
Are you using subreports?
Are you actually printing a form rather than a report (forms aren't for
printing)?
 
Here is the scenario:
1. The user enters yes / no data on a form for an individual
2. The user repeats this for 9 other individuals
3. A report is run which totals the yes's and no's for all individuals
4. The Navigation buttons on the bottom show 10 pages instead of 1.
5.The report snapshot is emailed and 10 pages instead of 1 are sent
help...
 
Did you look at the record source of the report?
What is the SQL view of the record source?
How is the report "run"?
How is the report emailed?
Are all of the pages exactly the same?
Is one page an accurate display of what you want for the report?

Which table has 10 records?
Are the yes/no fields across a record or multiple records (normalization
question)?
 
I have many questions on the first form.
There are many sql statements similar to "select count(questionx)
from answers"
The report is run via prinrpreview
The report is emailed via send to
All pages are exactly the same
the first page is what is needed to send via email
 
Do you understand how to "look at the record source of the report"? I was
expecting you would look at this in datasheet view to determine the number
and composition of your records.

Do you know how to determine "Are you using subreports?"

A report can have only one record source. I was expecting you to provide
this SQL statement to us.

We can't see what you can see so we must rely on you providing us with
significant information by answering our questions.

Can you tell us something about your table structure and your "many sql
statements"?
 
I discovered my problem! I saved my form as a report rather than starting
with a clean report. Saving as brings over the 10 records but a new report
brings 1.
Thanks for your questions which got me to think more.
 
Back
Top