need to repeat labels in access that may span more than one label

Experts,

Here is the problem.

I need to generate a business card size list of employees and phone #'s for a selected department in the company. As an example Accounting is selected and everyone in accounting and their phone #'s are selected.  I then need to print that list on a credit card sized report (label) and if that list is to large to fit on one card I need it to continue on the next card. Then I need to print one copy for each employee.

 I attempted to solve this problem with a report/subreport layout based on the same recordsouce and I get the correct copies and the parent layout is fine. But the continuation of a department to the second card will not work, I have spent two days trying to fix it and think I need a different solution.

example:

accounting 25 employees (only 20 will fit on a card)

card 1                     card2                      card 3                      card 4           repeat this layout 25 times
employee 1            employee 21      (same as card)   (same as card 2)
employee 2            employee 22
    '                          employee 23
    '                          employee 24
employee 20          employee 25

These cards are intended to be carried and change frequently so I want to print them in a label/business card format to simplify things.

Thanks in advance

Chip
Start Free Trial