I'm trying to Archive old records from two tables in my current database.
I know I need to create a make-table query to send the data, but first I want to create a new file so the archives can be distinguished between.
then once records have been archived I want to delete the records that have been archived.
I want to run it all from a form, using the following criteria:
I assume you are trying to archive by date. If so, you can use the dates on your form as the criteria for the query. Something like Between Forms![FormName]![txtStartDate] and Forms![FormName]![txtEndDate] You will need two text boxes on your archive form and a command button to run the query. The delete is just a delete query with the same criteria.