A
Ann Scharpf via AccessMonster.com
I have a 51,000 data table that's been exported from another system. About
11,000 rows would be considered duplicate data and should be deleted. The
table has a total of nine fields. Of those fields, a combination of three
identify a "distinct entry." The other fields contain data that I need to
retain but are irrelevant to identifying duplicates for deletion.
I've tried the SELECT DISTINCT function but you can't include the "extra"
fields and have the DISTINCT work. All the rows become distinct when I
include the other fields. I've looked in the help and at the postings here
but I can't figure out how to use several fields to identify a DISTINCT
record but still keep the other fields in the table.
I'd appreciate any information you can give me. Thanks for your help.
Ann
11,000 rows would be considered duplicate data and should be deleted. The
table has a total of nine fields. Of those fields, a combination of three
identify a "distinct entry." The other fields contain data that I need to
retain but are irrelevant to identifying duplicates for deletion.
I've tried the SELECT DISTINCT function but you can't include the "extra"
fields and have the DISTINCT work. All the rows become distinct when I
include the other fields. I've looked in the help and at the postings here
but I can't figure out how to use several fields to identify a DISTINCT
record but still keep the other fields in the table.
I'd appreciate any information you can give me. Thanks for your help.
Ann