Originally Posted by
John_G
You still don't need the archive date in the secondary tables. An append query can have more than one table in it as the source - but it can only append to one table.
So, in your append queries, just link the master table and one of the sub-tables using the AccountNum field. The criteria for the append query is then the archive data in the master table. If the ArchiveDate is to be included in the archived data (i.e. it is a field in the archive table), then just use the archive date in the master table as the source.