Junk

Ask something
Question Locked

Access: extracting most recent record from duplicate set

0 helpful
4 replies

by jessica.mihal

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm very green....
I'm working with a data set that contains duplicates. I ran a find duplicate query, but now need to delete all but the newest entry for each person. It is too big and happens too often to do manually. How can I filter/criteria/sort/??? to do this?

4 replies

by absolutely

If you can do that, then write a 'DELETE' statement where user name &/or case ID/whatever matches, but date does not match.

by jessica.mihal

It helped me explore new things - which may come in handy in the long run.

I'm not good with SQL language. I'm working in the grid view... so I guess I was alredy doing a select statement. I just don't know what operator or expression I could use to get what I need.

This discussion is closed to new replies.