Hi
During the day I will add some records to my table, they have 3 fields
1. RecID (Autonum)
2. MemID (Member Number this will differ.)
3. The data to be hold
Not all MemID will get the same number of records.
What I try to achive is.
I only want to keep the last 25 rec. for each MemID.
But I do not have a clue how to construct this SQL statement.
The DB is Access 2000.
Can anyone help.

Cheers
Karsten

Hello Karsten!
As a starting point u should know which Members have more than 25 records.
U solve the question running a Cross Reference Query on ur table having MemID as
rows, Date as columns, and RecID as value.Problem is that Access 2000 wont give u the total column directly. U will need to prepare two queries to have this column(Barker,F.Scott,"Microsoft Access 2000 Power Programming",pg 253,Sams Publisher).Next u pick MemID with more than 25 records using a simple query and delete the rows u dont want on ur table, one by one.
Trully Penta.