DELETE all records based the max date

[sal21]

I need to delete all records based CF and max date and maintain the newest....

for example CF=A007, delete all and maintain the only records with date 19/08/1974

naturally if CF have only a records maintain and not delete...

hope you understand me.

[HansV]

The table contains 4 date fields: DTIST, DCESS, DTAGG and AL.
Which field should we use?

[sal21]

The table contains 4 date fields: DTIST, DCESS, DTAGG and AL.
Which field should we use?

Sorry....
DCESS

[HansV]

SQL = "DELETE DCESS FROM HANS WHERE CF='A007' AND DCESS<(SELECT Max(DCESS) FROM HANS WHERE CF='A007')"

[sal21]

SQL = "DELETE DCESS FROM HANS WHERE CF='A007' AND DCESS<(SELECT Max(DCESS) FROM HANS WHERE CF='A007')"

But this delete all revordeset, entire raw?

[HansV]

It deletes entire records where CF equals 'A007' and DCESS is less than the maximum value for DCESS where CF equals 'A007'.

[sal21]

It deletes entire records where CF equals 'A007' and DCESS is less than the maximum value for DCESS where CF equals 'A007'.