Results 1 to 2 of 2
  1. #1
    Zukster is offline Novice
    Windows 98/ME Access 2003
    Join Date
    Aug 2009

    Delete duplicate records

    I have a query set up to find all duplicate records. Is there a way to run a query that will delete all duplicate records from a table?

  2. #2
    SpotoR1 is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2009
    Yes if you do a query and select the asterik and put in the field for ther query. The asterik means all fields in the table.
    Then select type of query, select delete query and when you run this, it will delete all records. Always make a copy of your database before making changes just in case you want something you deleted. This is a good practice to do. Once you delete the records you can't get them back.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Running a Delete (Records) Query on Close
    By NoiCe in forum Queries
    Replies: 1
    Last Post: 07-12-2009, 06:17 PM
  2. #delete records
    By supernova122 in forum Access
    Replies: 0
    Last Post: 07-08-2009, 08:41 AM
  3. Duplicate first row
    By kruai in forum Access
    Replies: 1
    Last Post: 06-22-2009, 02:06 PM
  4. Delete all records in a table?
    By bob646 in forum Access
    Replies: 1
    Last Post: 05-20-2007, 11:41 PM
  5. Which duplicate?
    By grgerhard in forum Import/Export Data
    Replies: 1
    Last Post: 05-27-2006, 06:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums