I need a VBA subroutine
I have a table with many field
In filed1 i have an ID and in field2 a date like
1010 10/12/2012
1010 20/12/2012
1030 01/01/2012
1030 12/12/2011
I need to keep a single record for each unique ID with the newest date value and delete all the other record from the table.
1010 20/12/2012
1030 01/01/2012
Any suggestions?
Many thanks