I'm using Access to print an Invoice/Statement report that requires three copies.  Each copy requires a different footer lable indicating who it goes to (Customer,Accounting,Department).  The document could be 1-n pages.  Having three different versions of the same report works but is a 'kludgy' solution.  How does one get Access to print multiple copies and change the footer on each?

You could:
1) store the department names into a database table (which I believe would print n*dept pages - but not sure),
- or -
2) put a variable name in the department field so that the department's prompted for by the user.

First things I can think of offhand.

Good ideas but I'm looking for something more inside the Access report.

The Departments don't change.  It's the same three labels every time, each on its own copy of the invoice (so, one report that prints three copies).  I suspect there is a way to count copies and, based on the count, substitute in the correct label caption. I'm just not sure how to make it work...