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.
 

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

Comb box from a field in 2 tables 2
Append record to another table 4
Using a Form to Archive Old Data 2
Access Dcount (multiple criteria) 3
How to export table from outlook into ms access table? 0
Checkbox to a query 11
Copy records from a form to a table 11
Form now Sub-Form, Query Broken 1

Back
Top