Archiving Information

[agates2]

I have a small database I built for a church membership program. I need a way to find, archive, and delete old members. Basically, pure the old info. I want to query the MEMBERS table for a specific STATUS and the TRANSACTION table for dates. I have those queries set up already! Now I want to copy the data from both queries into a new database and delete the original data from MEMBERS and TRANSACTIONS.
I would even be happy with the 2 queries creating the tables within the same database, as long as it deletes ONLY the specified data. Please help.

 

[jadams0173]

Use a delete query to delete the old records.

 

[agates2]

How can I create a new table to store the info in before I delete anything?

 

[PHV]

Either a MakeTable (SELECT ... INTO ...) or an Append (INSERT INTO ... SELECT ...) query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[missinglinq]

Since this is a db for church membership, the number of records is going to be relatively small. A simple method I've used in the past is to have a single checkbox named, for example, "NonActiveMember"

Set your form queries for active members to include all records where this box is not checked, and include a form for the non-active members where the box is checked. It's simple, and has the advantage of changing the member's status back to active if this should occur without re-entering all their data.

Hope this helps!

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[agates2]

That sounds like a better solution. Thanks for the help, guys!