Thanks Gina, I am renaming my tables, because I think it was poorly thought
out. I haven't figured out the problem yet, but renaming the tables will
probably make it easier for me to figure it out. I'll keep you posted.
r/David
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Gina Whipp
Sent: Friday, September 09, 2011 10:55 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Report printing multiple copies of the same
report
David,
Sounds like the RecordSource, which is probably a query, is the source of
the problem. You need to fix your joins and get the data to display in the
query correctly.
Thanks,
Gina Whipp
2010 - 2011 Microsoft MVP (Access)
www.access-diva.com
From: djsdaddy531
Sent: Friday, September 09, 2011 9:54 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] Report printing multiple copies of the same report
Great Day, I have a form that prints invoices for services performed by a
vehicle service center. there are two subreports: one displays the services
performed - brake repair, oil change, rotate tires, etc, and the other
displays the parts used for the repair - oil filter, oil, etc. The parent
report and subreports are all linked by RepairOrderID. The data appears to
print properly; however, I am getting multiple copies of hte same report.
there are 5 test records, and
one report does print only one invoice
two reports print 8 identical invoices
one report prints 2 identical invoices, and
the last report prints 20 identical reports (2 pages each)
Any suggestions on what I need to be looking for would be greatly
appreciated.
Thanks in adance,
David
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar