Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

Data Overrun in Report based on Avery Rotary Labels:5386

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?
0
ChuckStaley
Asked:
ChuckStaley
  • 2
1 Solution
 
nico5038Commented:
By manipulating the detailine hight and a grouping of the report on company, you should be able to achieve the wanted effect.
I would suggest to "drop" the subreport and to create the report as a grouped report on company. The access wizard will guide you when you start a new report and needs grouping...

Nic;o)
0
 
amp072397Commented:
ChuckStaley's last login mid-September. Points will be awarded to nico5038 unless Chuck returns with a viable objection.

thanks!
amp
community support moderator

(lots of mail, nico? LOL)
0
 
amp072397Commented:
Points to Nico.

amp
community support moderator
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now