Data Overrun in Report based on Avery Rotary Labels:5386
Posted on 2001-06-29
I am working with a co-worker who has a need to print out contact data for companies and multiple contacts within those companies. It seems that it works best to create a report in the detail section based on the measurements of the Avery 5386 (3" X 5"). The main report contains company addressing, phone & fax data. A subreport, located directly below contains the individual contacts within the company with their contacting data. It is possible for there to be 9 or 10 contacts per company. This means a positility of 18 lines. Because of this, the data for each company can extend beyond the boundary of the Avery 5386 card. Here is the question:
How do we go about telling Access to stop printing the queried data at 8 lines (4 contacts and associated contact data) and on the next Rotary card, re-print the main report data (Company contact info) and the REMAINDER of the individual contacts on the next rotary card?