Printing Multiple Labels

S

shewolf

Please help. I'm trying to print labels from a query but I need each
label to print multiple copies. The number of copies varies depending
on the value entered into a field titled Sheets. Unfortunately this
field is a text field. I didn't design the database and cannot change
this field to be numeric. I've searched and found various suggestions
for how to set a label report to skip blank spaces or to query for a
repeat value. But I can't seem to find anything that will work in my
situation.

I've tried creating another table with numbers in two fields, one being
a numerical field and the other a text. I then tried linking the
number as text field to the field called "sheets" and then using the
number as Number field but that tried to make the query repeat for
every Number not just the number of times shown in Sheets. Instead of
the total of six I should have gotten, I got 2002 entries.

I'm trying to avoid having to manually reenter all the values in a
label template in Word.

Any and all help will be GREATLY appreciated.
 
A

Allen Browne

So you have a Text type field that contains the number of labels you want?

Typecast the value to a number. In your query, type an expression like this
into a fresh column in the Field row:
CLng(Val(Nz([HowMany], ""))
where HowMany represents the name of your text field.

Now that you have a Number field in your query, you can use the solution
outlined here:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html
 
S

shewolf

Allen,

Thanks so much for the reply. Now I'm gettin another error though. I
copied and pasted exactly what you had and replaced HowMany with
Sheets. Then when I go to view the query results I get an error that
"the expression you entered is missing a closing parenthesis, bracket
or verticle bar".

I looked and there are three ( brackets and only two ) brackets so I
tried adding a third ) bracket at the end of the expression. When I do
that I get a "compile error" message. I see an opening and closing [ ]
around Sheets, so I don't think I need one of those.

Thanks so much,

Charis
 
A

Allen Browne

Noticed after I posted it that it does need the 3rd closing bracket:
CLng(Val(Nz([HowMany], "")))
 
S

shewolf

THANK YOU. You're awesome. Once I figured out that I needed to drag
that field into the other query I was on my way. You have no idea how
much you've helped me. Instead of having to manually type in 7 sheets
of labels, I can now run this report and just print them off. You're
my hero!
 
S

shewolf

I spoke too soon. I just realized that it ws making multiple copies
based on the highest number of entries in my field sheets. What I need
it to do is only print the multiples for that record.

So for example if Record A has five sheets it shoud print five labels
and if record B has twelve sheets it should get twelve labels. What's
happening is that I'm getting twelve of A and twelve of B.

Any ideas?
 
S

shewolf

Thanks so much. I don't know what I was doing wrong yesterday. Today
I just blew it all away and started from scratch and voila it worked.
You've been a huge help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top