Duplicates Query

[Bremen217]

Hi gang!

So I need a little help on a query. I have a table called duplicates.

There are say 10 columns but one colomn is "Internal ID" and another is "Created".

The internal ID column has records with the same value but other columns may be different.

What I need to do is run a query to delete these duplicates and end up with a table of Internal IDs that show up only once, and have the most recent "Created" date.

Ex Table:

Internal ID.....col....col.....col....Created
123..........................................12/24/2006
142..........................................11/11/2001
132..........................................08/14/2009
123..........................................10/11/2011
132..........................................07/06/1999
154..........................................12/11/2001


After running the delete query I would be left with:

Internal ID......col....col.....col....Created
123............................................10/11/2001
142............................................11/11/2001
132............................................08/14/2009
154............................................12/11/2001


Can someone please help?
Oh..By the way there are NO instances in this table where like Internal IDs would have the same "Created" date.
Thanks!
Bremen

 

[John Big Booty]

Perhaps this article will give you some pointers.

 

[Bremen217]

Thank you so much John! I had the group by query already created but was having issues getting it to link back and delete the bad records from the original table.

This article helped me complete the circle I had started!

You rock!
Bremen