Newbie problem with labels

[Jimmy]

Hi. I am new in Access and I have a problem which I can find no solution. I
have a report linked to a table, in that table we enter data from a form. I
want to print labels. The table has unique entries, no duplicates. It has 4
fields. FirstName LastName Address City. The labelsheet which I insert in my
printer contains 24 labels, the problem is that I need to have more than one
label of each record of my table. For example I need 8 labels of record1, 4
labels of record 2, 10 labels of record 15, and 2 labels of record 74. Or in
some other case I need all 24 labels to be from a particular record. I have
no idea how to do that. I don't even know if it is possible.
Can anyone help me?
Thank you
Jimmy

 

[John Vinson]

Hi. I am new in Access and I have a problem which I can find no solution. I
have a report linked to a table, in that table we enter data from a form. I
want to print labels. The table has unique entries, no duplicates. It has 4
fields. FirstName LastName Address City. The labelsheet which I insert in my
printer contains 24 labels, the problem is that I need to have more than one
label of each record of my table. For example I need 8 labels of record1, 4
labels of record 2, 10 labels of record 15, and 2 labels of record 74. Or in
some other case I need all 24 labels to be from a particular record. I have
no idea how to do that. I don't even know if it is possible.
Can anyone help me?
Thank you
Jimmy

You'll need to store the desired number of labels *somewhere* - since
I'm not sure just how you'll be using this, it's not clear just where.
But if it would be satisfactory, you could just add a HowMany integer
field to the labels table.

You can then create a second table, Num, with one integer field N.
Fill this table with numbers 1 to 10000 (at any rate more than the
most labels you'll ever want) - it's easy to build this table in Excel
and import it.

Base your Labels report on a Query; include your labels table and Num
with NO join line. Instead put a criterion on N of

<= [HowMany]

This will give you that number of copies of each label for your
printout.