Printing too many copies

J

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
 
J

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.
 
G

golfinray

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

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/
__________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top