On Sun, 12 Nov 2006 08:13:12 -0800, "Rebecca Smith"
<rebeccasmith00@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.
Quote:
>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
>
