Results 1 to 3 of 3

Thread: Deleting duplicate records (but keeping one original)

Hybrid View

  1. #1
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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.

  2. #2
    Join Date
    Oct 2006
    Location
    Maitland NSW Australia
    Posts
    275
    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
  •