Deleting Duplicate Records in a Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I know there are numerous posts about deleting duplicate records, but I am
too big of a novice in sql and Access to adapt their questions/answers to my
problem. I have 1 table called structure_existing_area_3 that has duplicate
records. I need to get rid of these duplicates.

They are considered duplicates if two fields, "right_fid" and "length" are
both the same. The other fields may have different values, but if these two
fields match for two different records, I need to delete one of the records.

Just to be clear (and redundant), following is an attempt to re-create an
example of a duplicate record.

left_id---right_fid---length
---1--------2----------3
---5--------2----------3

Because both fields match at the same time, it is considered a duplicate. In
this instance, I want to get rid of one of the records (doesn't matter which
one)

This is not a duplicate record:

left_id---right_fid---length
---1--------5----------3
---5--------2----------3

If anyone could explain, step-by-step, how to do this in design view, or
write out the sql statement for me, it would be greatly appreciated. Again, I
am fairly inept at Access and sql, so please be detailed and clear.

Thanks in advance
.

Relevant Pages

  • Re: Error in post with ADOSQLServer
    ... > Yes is one table with 86.500 record!!, I need delete all duplicate record. ... SQL is complaining that it ... Maurice ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Redundancy
    ... I need to create a duplicate record into another database when I create a record in the current one. ... I'm using the SQL INSERT Command. ... How would I send a copy to another database with SQL? ...
    (microsoft.public.access.formscoding)
  • Re: Deleting Duplicate Records in a Query
    ... I need to get rid of these duplicates. ... example of a duplicate record. ... Because both fields match at the same time, ... write out the sql statement for me, ...
    (microsoft.public.access.queries)
  • Re: Deleting Duplicate Records in a Query
    ... I need to get rid of these duplicates. ... example of a duplicate record. ... Because both fields match at the same time, ... write out the sql statement for me, ...
    (microsoft.public.access.queries)