Hey folks,
Don't know if what i'm trying to do here is possible...but i'll ask it anyway.
I'm looking for a way to delete records in a table that have the same ID# but have different dates associated.
Eg;
ID Date Value
1 28/08/02 ABC
2 28/08/02 XYZ
1 29/08/02 JKL
In this instance...the first record would be deleted, as it is the oldest instance of the record with ID# 1
As usual, i'm sure there are many differents ways to achieve this, and any help is welcomed
Cheers
-Jezza
Don't know if what i'm trying to do here is possible...but i'll ask it anyway.
I'm looking for a way to delete records in a table that have the same ID# but have different dates associated.
Eg;
ID Date Value
1 28/08/02 ABC
2 28/08/02 XYZ
1 29/08/02 JKL
In this instance...the first record would be deleted, as it is the oldest instance of the record with ID# 1
As usual, i'm sure there are many differents ways to achieve this, and any help is welcomed
Cheers
-Jezza