multiple copies

D

David French

I have several reports that are printed on a periodic basis and sent out to
our salesmen.
Depending on how many salesmen cover a particular county dictates how many
copies need to be printed.

Is there a way, by report, to dictate how many copies print?

For instance Report 1 needs 3 copies.
Report 2 needs 5 copies.
Report 3 needs 8 copies.

The number of copies is relatively static per report unless a salesman
changes territory or leaves or one is hired.

It is simply a drag to have to count out the number needed each time.

OK ok...i don't want to think!

Dave French
 
D

Duane Hookom

Assuming you have a [County] field in your report's record source and
[County] field in your salesmen table:
Add the salesman table to the report's record source and join the County
fields. This should create one set of records for each salesman in the
county for each report.
 
D

David French

I see the outputto command but how about the # of copies?
I'm not finding that.

I'm using Access 2000 in this case on a Windows 2000 OS.

Dave French
 
Top