Delete Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.
I'd like to create a query that checks for duplicate records and deletes the
record that, on an autonumber field, has the smaller value?

Thanks.
 
You can use the duplicate query wizard to find the duplicates. Implementing
the logic to delete the smaller of the two may require a second(or third)
query, or VBA.
 
Back
Top