-
One way to do it is to create a temporary table with records you want to keep and writing a delete statement to delete everything in the original table and not in keep table.
-
1. Create a temporary table
2. Set the primary Key to First Name, Surname and Postcode
3. Create an APPEND query to append the original table to the temporary table.
4. Run the query, a message will be displayed after the query runs saying " X number of records could not be appended due to record violations" or similar wording select YES and your temporary table should now contain no duplicate records.
5. I suggest test the query using sample data to ensure that only 1 copy of the duplicate records is in the temporary table
Allan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|