which record is deleted when I use the "remove duplicates" functi.

  • Thread starter Thread starter amcellhinney
  • Start date Start date
A

amcellhinney

I want the oldest record to be deleted, not the newest when I find the same
customer - how can I ensure this happens?
 
Hi,

what does your data look like? How do you know which record is the oldest?
What if there are more than two records? Could you should us a sample data
layout?
 
You must log in or register to reply here.

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

Remove duplicates 2
Date Comparison in the same column 6
Access Auto Matching Duplicates? 0
How to delete all duplicate records - without keeping one of them 5
won't view last message received 2
How to Delete duplicate row access 2003 0
Outlook - Message Delete Order 3
Eliminate Duplicate Entries in Order to Create Labels Using Mail M 3

Back
Top