Report Footer Help Needed Please

[TK]

I have a report (a bill of lading) that I want to print 4 copies of. But at
the bottom of each page I need a different statement printed (1st copy -
"Original", 2nd copy "Customer Copy", 3rd copy "File Copy", etc.)

Can anyone guide me in the right direction to accomplish this?

 

[Duane Hookom]

Allen Browne has a page on printing multiple duplicate labels at
http://www.allenbrowne.com/ser-39.html. You should be able to adapt the "A
Better Solution" to your needs. Come back if you have an issue.

 

[TerryD]

Duane:
Thanks for your quick response. I tried this, but I can not get it to work.
Any other suggestions?

Thanks,
T

 

[Duane Hookom]

"but I can not get it to work" It looks fine from where I am. Maybe you
should try to explain your results and why they don't "work".

 

[Gina Whipp]

Found this:

Another simple solution to produce multiple copies is to create a table
(tblPrintCopies) with a single integer field. Add one record for each copy
required (1,2,3,4,5 etc). Add this table to the recordsource of the report
with no joins to any other table. When the recordsource query is run,
because a relationship between tblPrintCopies and the other table(s) cannot
be established the query will produce a line for each entry in
tblPrintCopies. So if tblPrintCopies contains 5 records, the recordsource
will produce 5 records for each "true" record in your other tables, as such
when printed, the report will generate 5 copies.

If you want to actually show a copy description in your report , instead of
using integers in tblPrintCopies use a text field and enter records for
"Original", "File Copy", "Customer Copy" etc. Drag this field into the
recordsource and bind a control on your report to this field. When printed
each
copy will be identical except for the copy description field.


Wayne Gillespie
Gosford NSW Australia