Purging records script help needed

[Raymond P Reedy]

I have a table with three fields (ID, Date, Score) sorted by Date  
descending. Some IDs have 52 records, some have 25, and some have  
fewer than 10.

With year-end approaching I need to purge, retaining only the most  
recent 10 scores. This is an annual purge, so I am looking for the  
easiest way to purge. I was thinking of an export to Excel, delete  
manually, and import. Or is there an easier way?

Ideas?

Ray

Raymond P Reedy
[EMAIL PROTECTED]