Archiving records in a table

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

Guest

Hi,

I have a form that allows users to add/edit records into a table called
LabTests. The number of records is starting to get long. What we want to do
is to start archiving records. Everything that is greater than a month old
and has a value in the CheckNumber field would be good records to archive.
Is there a way to create a query that will enable us to archive records into
another table called LabTestsArchives?

Thanks,
 
You can build an append query to add them to another table, then a delete
query to delete them. Personally, I don't do this very often. Instead,
just elliminate the old stuff from your forms, reports, and queries. Just
modify your queries or create one called "Current Lab Tests" and put
criteria in it to only pull items without a check number OR with a check
number, but less than one month old.

Use this query instead of your table to create all other tables, queries, or
reports.
 
Back
Top