Removing duplicates

[Saadi]

DISTINCT removes duplicate records where the combination
of fields in a record equals the combination of fields in
another record.

How can I remove duplicates where the combination of
fields in a record is not exactly equal to the combination
of fields in another record,i.e., there is a match on 3
out of 5 fields.

Example:
Code Name Address1 Address2 Address3
1AB XYZ 123 Rd City State
2BC UVW 123 RD City State

Thanks,
Saadi

 

[Dennis Schmidt]

Hi Saadi,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

The following Knowledge Base article should get you going in the right
direction:

1-Copy the table structure of the table containing all the records.
2-Edit the design of the table so that you have a three field primary key
(comprised of the three fields you want to match).
3-Append the records from the original table to the new table.

When you append, it will allow the first record and skip the remaining
records if they have the same data in these three fields. You won't be
able to choose which record to keep, Access will just take the first in the
process of filtering the records.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support