I have a Access 2010 database that comprises of one main table, and several linked tables. The main table is now getting very large, and I would like to archive any records which 'expired' more than 2 years ago. I know that I could do this straight forward operation using an appand query, but I need to knopw how to make sure that the related data in the linked tables is also archived where appropriate. i.e. Some of the linked data is directly linked to specific records in the main table so can also be archived, but some is linked to several records, not all of which will be eligible for archiving.