Michael check out the following video:
Archive Records

Thanks Sami, but not quite what I am looking for.  I want to be able to archive old data from 2 related tables into 2 Archive tables.  Basically if the master record is archived, I want to archive the child record.  The videos, which I had previously viewed, only talk about how to archive 1 table using the append query and then how to tell which record you are viewing (current or archive).  Big difference from what I am looking to do.

I am assuming you have a proper relationship between the 2 tables?  If so, then build a tmp table from the Main table of those records you want to archive using a make table query.  Then, take the tmp table from the main table and link it to the 2nd table and build a table that would essentially be the archive table of the 2nd table.

Once you have those created, then link the tmp table 1 to the main table and delete those records.  Then take that table and link to the 2nd table and purge those records.

Thanks John.  I'll give it a try.

If you are familiar w/ VBA, this can be done in a button, or a series of queries can be run in a specific order to perform all the necessary tasks.  Please do yourself a favor and get the new functionality working in a copy of your original database, so that no loss of data can occur during development until confirming everything performs as planned.

• Append Query to + records to QuoteArchive where criteria = checkbox, date or other value determines archivability
• Append Query to + records to QuoteNotesArchive where unique relationship field in QuoteNotes=QuoteArchive
• Delete Query to – records from QuoteNotes where unique relationship field in QuoteNotes=QuoteNotesArchive
• Delete Query to – records from Quote where unique relationship field in Quote=QuoteArchive

Suggesting the latter 3 steps to be a WHERE using the unique relationship field, so that if the queries were to inadvertently be run out of order, no deletions can be performed on records not already carried over.