Delete Query

L

Luis

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

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