Multiple Mail Labels

[Rebecca Smith]

I'd like to print mailing labels. Simple enough eh? In the db I just took
over, the previous fellow had some names listed multiple times, if those
folk got more than one copy of the our monthly newsletter. I'd like to clean
things up and have each name listed just once. Ideally, I'd have a column
for 'number of copies'. Then, when my label report ran, it would read this
number and print X number of labels. Is this possible? If so, can anyone
offer a suggestion about how to set it up code wise?
Thank you.
Becky

[Tom van Stiphout]

On Sun, 12 Nov 2006 08:13:12 -0800, "Rebecca Smith"
<re************ @comcast.netwro te:

Of course there could be more than one "Jim Jones" in the world, but
if you have true duplicates in your table you need to start with
improving the database design. Put a unique index on the (combination
of) fields that makes a record unique. This will initially fail, so
you have some cleanup to do, but then it will work and will never fail
again.

Printing the "number of copies" like you indicate is a bit harder than
it may seem. Are you sure you need to go down that road. Cannot Jim
and Sally Jones share the same copy?
If not, I would probably pre-process the report by writing the records
I need to print to a "temporary" table using some VBA code with
recordsets. In this table the indexes are relaxed to allow
almost-dups. Then the label report would print from that table.

-Tom.

>I'd like to print mailing labels. Simple enough eh? In the db I just took
over, the previous fellow had some names listed multiple times, if those
folk got more than one copy of the our monthly newsletter. I'd like to clean
things up and have each name listed just once. Ideally, I'd have a column
for 'number of copies'. Then, when my label report ran, it would read this
number and print X number of labels. Is this possible? If so, can anyone
offer a suggestion about how to set it up code wise?
Thank you.
Becky

[Karl]

Create a new table with one column called say NumberOfCopies. If you need 4
copies of a label type 4 in 4 rows of this table.
If you need 6 copies of a label type 6 in 6 rows of this table.

In the table with the names, add a column called say NumberOfCopies and
enter 4 or 6 or however many labels you want for each name.

Then link these 2 tables together in a query and use the query to make the
labels.

"Rebecca Smith" <re************ @comcast.netwro te in message
news:Wr******** *************** *******@comcast .com...

I'd like to print mailing labels. Simple enough eh? In the db I just took
over, the previous fellow had some names listed multiple times, if those
folk got more than one copy of the our monthly newsletter. I'd like to
clean things up and have each name listed just once. Ideally, I'd have a
column for 'number of copies'. Then, when my label report ran, it would
read this number and print X number of labels. Is this possible? If so,
can anyone offer a suggestion about how to set it up code wise?
Thank you.
Becky

[Rebecca Smith]

Karl,
Intriguing
B.

"Karl" <so*****@sbcglo bal.bizwrote in message
news:w7******** ***********@new ssvr21.news.pro digy.com...

Create a new table with one column called say NumberOfCopies. If you need
4 copies of a label type 4 in 4 rows of this table.
If you need 6 copies of a label type 6 in 6 rows of this table.

In the table with the names, add a column called say NumberOfCopies and
enter 4 or 6 or however many labels you want for each name.

Then link these 2 tables together in a query and use the query to make the
labels.

"Rebecca Smith" <re************ @comcast.netwro te in message
news:Wr******** *************** *******@comcast .com...

>I'd like to print mailing labels. Simple enough eh? In the db I just took
over, the previous fellow had some names listed multiple times, if those
folk got more than one copy of the our monthly newsletter. I'd like to
clean things up and have each name listed just once. Ideally, I'd have a
column for 'number of copies'. Then, when my label report ran, it would
read this number and print X number of labels. Is this possible? If so,
can anyone offer a suggestion about how to set it up code wise?
Thank you.
Becky

[Rebecca Smith]

Karl,
Works like a champ - thanks!
B.

"Karl" <so*****@sbcglo bal.bizwrote in message
news:w7******** ***********@new ssvr21.news.pro digy.com...

Create a new table with one column called say NumberOfCopies. If you need
4 copies of a label type 4 in 4 rows of this table.
If you need 6 copies of a label type 6 in 6 rows of this table.

In the table with the names, add a column called say NumberOfCopies and
enter 4 or 6 or however many labels you want for each name.

Then link these 2 tables together in a query and use the query to make the
labels.