Archive some older records from a table

  • Thread starter Thread starter Gail
  • Start date Start date
G

Gail

I am looking to find a way to archive some older records
from a table. I currently have about 1000 records in the
table and would like to only keep the most current records
visible. I will still need the older records available
for reference.

Is there a simple way that I can set this up and how do I
do it?

Any suggestions will be greatly appreciated.
Thank you in advance for your help.
Gail
 
Good Afternoon!

There are lots of ways to do this. One of the most simple
would be to create a new table to store the archived
records in and then use an append query to select and
write those records to the new table. After this was done
you could run a delete query to remove the archived
records from the original table.

Dan
 
Gail

A possibility for identifying the age of the records could be done via an additional field with autonumber or date/time when inserted in the table, then you could try to select on that field to copy the older ones to another table and delete them in your original table
If you use date/time you could select every record older than e.g. 10 days (date < today()-10) or if you use autonumber get the oldest e.g. 100 (number < highest number - 900)

Bernd
 
Back
Top