Report Footer Help Needed Please

  • Thread starter Thread starter TK
  • Start date Start date
T

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:
Thanks for your quick response. I tried this, but I can not get it to work.
Any other suggestions?

Thanks,
T
 
"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".
 
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
 
Back
Top