Multiple Labels

[Guy Lydig]

I have a table with a list of people. I want to create multiple labels for
some of the people but different numbers for each. For instance:

Monday: 8 labels for Mr. A, 3 labels for Mr. B, none for Mr. C.
Tuesday: 4 labels for Mr. A, no labels for Mr. B, 7 labels for Mr. C.

Please help. (I know how to create the same number of multiple labels for
every record in a table but I cannot do the above.) Please be explicit
because I am a novice.

 

[Danny J. Lesandrini]

So, is your question ... How do I create a recordset witn x instances of record A,
y instances of record B and z instances of record C? And these quantities are
dynamic?

I ask that because I like that question better than, "How do I create labels?"

The first thing we'd need to know to answer the upper question is how do you know
the values of x, y and z? How do we know Mr A gets 8 labels on Monday and 4 on
Tuesday? Is that info in a table and/or could it be loaded into one?

Let's say Mr A has the PersonID of 123 and Mr B has the PersonID of 987. If you
could load a table with data like shown below, you could link it to the table with the
actual address for PersonIDs 123 and 987 to create a query with the right counts.

PersonID DateInQuestion
123 Mon Feb 2, 2009
123 Tues Feb 3, 2009
987 Tues Feb 3, 2009
987 Wed Feb 4, 2009
123 Thur Feb 5, 2009
123 Fri Feb 6, 2009

Just link this table on PersonID to your person table with the addresses and you'll
have a query that may be processed to deliver the correct number of lables for a
given day.

 

[Allen Browne]

See:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

The example assumes your table has a number field that tells how many of
each record you want printed.