 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / December 2006BusinessCard Labels multifields
I have a database with stations and phone numbers and departments in one table. I want to print all the numbers for one department on one side of a business card, all the numbers in a special group on the other. I have used the label wizard but cannot get more than one station and number on one business card. txtBox=[station]&" "&[Number] Is this beyond Access capability? Thank You You can use a subreport in a label report.  SignatureDuane Hookom Microsoft Access MVP > I have a database with stations and phone numbers and departments in > one table. I want to print all the numbers for one department on one [quoted text clipped - 5 lines] > > Is this beyond Access capability? Thank You Duane: Thank you for pointing me in the right direction. Sub Report inside that label report template does the trick, Very neat. Appreciate your help! Happy New Year > You can use a subreport in a label report. > -- [quoted text clipped - 10 lines] > > > > Is this beyond Access capability? Thank You Duane: Thank you for pointing me in the right direction. Sub Report inside that label report template does the trick, Very neat. Appreciate your help! Happy New Year > You can use a subreport in a label report. > -- [quoted text clipped - 10 lines] > > > > Is this beyond Access capability? Thank You > Is this beyond Access capability? It may be beyond the (unmodified) Wizard's capability. I seriously doubt that the Wizard was designed with your particular requirements in mind. It isn't beyond Access' capability. Larry Linson Microsoft Access MVP Any thoughts you may have would be appreciated, I am still working on this through another approach in another thread. I am stumped on the page length of the sub report overriding the 2 inch high column of the label report. > > Is this beyond Access capability? > [quoted text clipped - 5 lines] > Larry Linson > Microsoft Access MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.