Printing Address Labels

P

Paul Fenton

We have a database that looks like this (t-shirt orders):

Name SM MED LG XL 2X 3X

John 1 1
Joe 1
Mary 1 2
Bill 1

I want to print labels for the bags that will hold the t-shirts at
distribution and I want the labels to look like this:

John
1 Small
1 XL

Joe
1 Med

Mary
1 Med
2 LG

Bill
1 2X

Need some help on how to go about this. I don't know a lot about
crosstab queries, either.


Paul Fenton
[email protected]
 
W

Wayne-I-M

Hi

You don't need a crosstab query.

Just create a select query based on the table and create a report based on
that. In the report insert an unbond text box. Use this as the control
source

=[Name] & Chr(13)+Chr(10)+[SM] & Chr(13)+Chr(10)+[MED] &
Chr(13)+Chr(10)+[LG] & Chr(13)+Chr(10)+[XL] & Chr(13)+Chr(10)+[2XL] &
Chr(13)+Chr(10)+[3XL]


Dont forget to set the text box to can shrink = no or the lable may move up
if there are more or less lines.

In the page set up (it's on the file menu) set the page to print lables to
fit what you want.

HTH
 
P

Paul Fenton

Thank you, Wayne. I found another workaround that looks like it will
do the trick.

Paul Fenton
 
Top