BusinessCard Labels multifields

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
 
J

Jeff C

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

Jeff C

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

Larry Linson

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
 
J

Jeff C

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

Jeff C

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
 
Top