Printing Address Labels

[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
(e-mail address removed)

 

[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

 

[Paul Fenton]

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

Paul Fenton