Run duplicates query and delete duplicates?

[Guest]

Good Day all,

I am trying to run a duplicates query on a database closing
(qryfindduplicatedesignnumbers), and upon running the duplicates query I
would like to delete the oldest duplicate.

does anyone have any ideas on how I can accomplish this?

Thanks.

Brook

Please let me know if you need more information.

 

[Jeff Boyce]

Brook

Without more details, it sounds like you could run a Totals query on the
results of your duplicates query taking the minimum value of your date field
(?"oldest"). This would help you identify candidates for deletion. What do
you want to have happen if there's more than one (duplicate) record with the
same (oldest) date value?