If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Deleting duplicate records
I have a table: [Related Submissions]
Fields: Autonumber (Primary key), [SUbmission Number 1], [Submission Number 2], Relationship Using Access 2002 I want to remove duplicate records where for two records, [Submission number 1], Submission Number 2] and Relationship are the same. It is easy to find the duplicates, but is there any way to remove one of the duplicate records? Thanks Alice |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to identify duplicate records and count them | vishal | Worksheet Functions | 1 | June 6th, 2004 06:33 PM |
duplicate records, how to identify and count | Andy B | Worksheet Functions | 2 | May 26th, 2004 02:57 PM |
Determine duplicate records | singkit | Worksheet Functions | 2 | March 23rd, 2004 04:52 PM |
Duplicate Records | Jas | Worksheet Functions | 4 | January 28th, 2004 09:00 PM |
Deleting duplicate records | danldata | Worksheet Functions | 2 | December 11th, 2003 10:03 PM |