Remove Duplicates based on Date Added
Posted on 2011-09-14
I have an Access Table named tbl_TestAll that I need to delete duplicates based on the Date Added date.
DtA is the Date Added field
The column names are liks such.
Cha, Allo, Tar, Cons, Opt, Des, Pct, Len, Cur, Com, DtA, For, Mar.
The rows are as such:
Row 1 Ca1, Allo1, Tar2, Cons1, Opt 1, Des1, Pct 3, Len1, Cur2, Com 2, 7/14//2001, For1, Mar1
Rpw 2 Ca1, Allo1, Tar3, Cons1, Opt 1, Des2, Pct 4, Len2, Cur3, Com 2, 9/14/2001, For1, Mar1
So basically, Cha, Allo, Cons, Opt, For, MarI are duplicated in both rows.
I need a query that will delete Row 1, and keep Row 2 based on the latest date.