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