On Sun, 12 Nov 2006 08:13:12 -0800, "Rebecca Smith"
<re************@comcast.netwrote:
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