Query

[sha123]

Is there a way of creating a delete query that delete all the entries in a table except the last record?

 

[nicsin]

Can you give us some details like the table's structure along with some test data?

 

[JonFer]

You would need an autonumber field or a "last updated" field in the table.

Your delete would be like:

Delete * from YourTable
Where Field <> (Select Max(Field) from YourTable) ;

 

[nicsin]

JonFer,

sha123 wants to delete everything but the LAST record

 

[JonFer]

Assuming [Field] has the highest value on the last record (like for an incremental autonumber or a &quot;last updated&quot; date), the delete will work. I don't like using the &quot;Last&quot; aggregate function because it is dependent on the record sort which you don't always know.

 

[nicsin]

I probably misunderstood the 'last', thinking 1st record, 2nd record ... last record and not the last inserted record. I personaly agree with you about the

last

function.