Delete Query

[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.

 

[[MVP] S.Clark]

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.