ACC2000: How to Delete Duplicate Records in Two Tables (209573)
The information in this article applies to:
This article was previously published under Q209573 Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
SUMMARY
This article shows you how to delete duplicate records from two tables and
to retain the most current information (records). In addition, the article
shows you how to merge the results of these two tables into one table.
REFERENCESFor more information about deleting duplicate records, click Microsoft Access Help on the Help menu, type deleting duplicate records in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Major | Last Reviewed: | 6/24/2004 |
---|
Keywords: | kbhowto kbusage KB209573 |
---|
|