Delete all, left only the last 10 records.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a table which stores events made by users. Each record has timestamp
which is the time it was created. I want upon openning database, remove all
old records and left only the last 10 records. Can I do that by one SQL
command ?

I want to execute
DoCmd.runSQL sqlstatement

But I can not figure out that SQLstatement.

Thanks for help
Quang
 
Tran said:
Hi,
I have a table which stores events made by users. Each record has
timestamp which is the time it was created. I want upon openning
database, remove all old records and left only the last 10 records.
Can I do that by one SQL command ?

I want to execute
DoCmd.runSQL sqlstatement

But I can not figure out that SQLstatement.

Thanks for help
Quang
Click to expand...

DELETE * FROM TableName
WHERE PrimaryKeyField Not In(SELECT TOP 10 PrimaryKeyField FROM TableName ORDER
BY TimeStampField DESC)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert a record and another record does not work 7
Get Record Just Appended 3
Mail merge to Word from Access 2000 1
Only merge a new record, not all 2
Query to retrieve only the latest records 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
How to make a record appear as the top record on the screen? 7
Search a data (EmployeeName) from all the tables in the database m 7

Back
Top