BusinessCard Labels multifields

  • Thread starter Thread starter Jeff C
  • Start date Start date
J

Jeff C

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
 
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


Duane said:
You can use a subreport in a label report.
--
Duane Hookom
Microsoft Access MVP


Jeff C said:
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
Click to expand...
Click to expand...
 
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


Duane said:
You can use a subreport in a label report.
--
Duane Hookom
Microsoft Access MVP


Jeff C said:
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
Click to expand...
Click to expand...
 
Is this beyond Access capability?
Click to expand...

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.
 
Detail section is set to Can Grow = No

I am trying to figure this out. If you have time, please see new
thread in Access Reports

Full Page of (10) Labels

Thank you very much
 
Back
Top