Archiving records from one table to another

[chubbychap]

Hello All

I should know this one, but I've given up on trying to figure it out!

On pressing a button, is there a way to move records from one table to another, providing certain criteria have been met?

E.g. A date is entered into a "Close Case" field. Every so often the user can click a button on a form and clear out all "Closed Cases" (records with a date in the said field) from the main table and move them to an Archive table.

If anyone can help with this, or point me in the right direction of where to look, it would be greatly appreciated.

Many Thanks

Chubbychap

 

[Parra]

You can create an Append Query.

Just add the criteria you want met to the query, and it will only append those records that meet your criteria.

Parra

 

[Ziggy]

Use an append query based on the first table, you can select which table to append to. Place all the fields that are contained in the destination table and put a criteria like "<>Blank" in the criteria field for date to only append those records.


Then also set up a delete query for the first table to delete the records that meet the same criteria.

Now in a Macro tied to a button select the actions to run query and put 1st the append query and then the delete query. This way the data will append to the table and get deleted from the first.


Ziggy

 

[chubbychap]

Thanks Ziggy

Thanks Para

I'm now back in Business!!! The most obvious things are always just under your nose.

Chubbychap