Deleting one record from the result of duplicate query

N

nadine

My Issue is that as a result of an append query I get duplicate records. The
Duplicate record has an auto number so I only want to delete the oldest
record which would be the min Value ,but I cannot get the query to work . Any
suggestions

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How does one eliminate blank records on a query result? 3
Duplicate hashtags in OneNote 0
Autonumber field in Excel that behaves the same as Access 0
Mail Merge skipping records/sending one at a time 0
Append problem Duplicate key 0
Duplicate records - eliminate from totals 11

Top