Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: delete duplicate records with condition

    Hi, I have a table that has 3 fields - ID, Name and Stage.
    The table contains the following record
    ID Name Stage
    1 Jane 1 #
    1 Jane 2
    2 David 4
    3 Judy 2 #
    3 Judy 3
    4 John 3 #
    4 John 4
    5 Carl 1

    I want to delete those records that are duplicated but with a low stage number (ie the # ones). I used the query to find out the duplicate ones with a MIN(stage), but then I can't delete those fields. What can I do?

    Thanks for helping.

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    You can delete the repeated items using a RecordSet

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •