Printing too many copies

[Jacqueline]

I have set up a report that is actually just an information/direction sheet
for my scheduling assistants.

I all the margins are correct, it does not have a header or footer. When I
go to print preview it comes up with 188 pages, and it is only a 2 page
report; I am getting 94 sets of the same report.

I have noticed this happening to me a lot latly and wonder if I have screwed
up some setting some place. I have done every thing I can think of, looked at
all the properties, but cannot figure this one out.

Can someone out there help with this? Oh, I am useing Access 2007
Thanks
Jaqueline

 

[John W. Vinson]

I have set up a report that is actually just an information/direction sheet
for my scheduling assistants.

I all the margins are correct, it does not have a header or footer. When I
go to print preview it comes up with 188 pages, and it is only a 2 page
report; I am getting 94 sets of the same report.

I have noticed this happening to me a lot latly and wonder if I have screwed
up some setting some place. I have done every thing I can think of, looked at
all the properties, but cannot figure this one out.

Can someone out there help with this? Oh, I am useing Access 2007
Thanks
Jaqueline

Yes, you've screwed up something - most likely the Query upon which the report
is based. It's likely (though you don't say!) that you're launching the report
from a Form and that it's based on a query which you INTEND to show only two
pages, but the query is actually returning 94.

Open the report in design view and view its Properties; click the ... icon by
the Recordsource property; and open the query in datasheet view. Do you see a
lot of duplicated data? Does the query perhaps include a table that it needn't
(one with 94 records to be exact)? Post the SQL view of the query if you can't
tell.

 

[golfinray]

I would start with File\Page setup\Page then try your printer driver
configuration.

 

[Tom Wickerath]

Hi Jacqueline,

Is your report based on a query that includes more than one table? If so,
the query might be returning way too many (duplicate) records. A possible
cause is a missing join between the tables, so you end up with what is known
as a cartesian product result, ie. the number of records selected from Table
A multiplied by the number of records selected from Table B.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________