How do I print multiple copies of the same record on labels?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to print labels of names & I need to print each name 6 times. How can
I get Access to repeat the records on the same sheet of labels instead of
just telling the printer to make 6 copies. I will have like maybe 10 names &
I dont want to waste labels by starting a new page every 10 names.
 
Create a table with one field named Numbers. Fill that field with 1 to 6.
Create a query that includes this number table and the table that has the
Names. Base your label report on this query. You will get six labels for
every name in the table.
 
What if my number varies from record for the amount of time that I would like
to repeat that record in my labels sheet, I have only found information for
telling it to print it a specific amount of times, but I need to know how to
vary it from record to record. Any help that you could offer would be
greatly appreciated
 
Are you storing the "number" in your record? What is the field name that
stores the number? What is the maximum number of copies for any given
record?
 
It does not seem that Ben replied to your question, I will: I am storing the
number in my record. The field name is "OQUAN". The quantity of labels
needed could be from 1 to 200 maximum. Record # 1 I may need to print 5
labels, record 2 maybe 10, record 3 maybe 20, record 4 = 60, etc. It's
driving me nuts trying to figure this out!
 
I have this same problem. I want to take the qty field and print that qty of
labels Is there a way to repeat the label the amt of times the qty?
 
I did figure it out:
1. Build a new table named "Table Count" containing one field named
"number". Populate the field with numbers 1 ,2,3,4, etc up to the amount
of labels that you would ever print. (I did 300). This should be the
primary key in your table.
2. Create a new querry using both tables, "Table Count" and your table with
your "qty field" etc in it. Do not join the two tables.
3. In the results the you want to see in your querry select the fields that
you want to print on the labels. Then select the "number" field from the
"Table Count" table.
In the criteria line type "<=qty" assumming that "qty" is the name of your
field in your main table. When you click run you should see the results that
you are looking for. It should repeat the record as many times as the "qty"
field states.
4. If that all works you can use the label wizard in the report section to
create your labels.
Write back with questions if I did not make myself clear.
 
Thanks for your reply.
It make sense but I get a data type mismatch for some reason both the qty
and the num are data type number so I'm not sure what's going on.
 
I Just figured it out I needed to use []. Thanks for your help. My brain
will be able to sleep tonight :)
 
PLease I have the same problem.. I've already create my query, and when I
select Record Source Query, then it says data type mismatch in criteria
expression, how can I do to solve this???
 
Back
Top