Print different footers on report.

[Terry]

Hi:

I'm still trying to figure this problem out. I have a report (a picking
Ticket) that I need to print. Each time it is printed I need 4 copies of
the report. However on the first copy I need the footer to say "Original
Copy", on the second copy I need it to say "Customer Copy", third page -
"File Copy", fourth page "Accounting Copy".

Some kind person did try to help on this about a week ago, but I did not
have any luck.

Any suggestions on how to accomplish this task would be greatly appreciated.

Terry

 

[Rob]

just one studip awnser:
Create 4 different reports and print then one by one

 

[Al Campagna]

Terry,
How are you calling the 4 copies... via your printer NoOfCopies setting?
I assume your printing one ticket 4 times.

I would suggest a small table lie this
SortOrder CopyDesc
------------------------------
1 "Original Copy"
2 "Customer Copy"
3 "File Copy"
4 "Accounting Copy"

Add this table to your query behind the report... with no join. This is
a cartesian realtionship. This will case 4 tickets to be delivered to the
report... each ticket with it's own sorting and desc for your footer.
Group and Sort your report on SortOrder, and cause a page break after
each ticket.
An unbound text control in the page footer, with a ControlSource of...
= [Desc]
should display different values, each on it's own ticket page.
Haven't tested this exact setup, but I've used the Cartesian relationship
before, for creating X copies of the same address label.
This is the way I'd go at it.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."