I have a table of values in a table called UpdateTable. Before i do the update though i want to copy the entire record for archive purposes. I would like to know how to create an append query that uses another query as the criteria. ie;
UpdateTable - holds current values to be used to update MainTable
MainTable - holds all the data
ArchiveTable- a copy of the entire record that was updated even if only one value was updated
I would like to know how to use a query as the criteria for an update query so I can get a list of all CarIDNumbers in the UpdateTable and use that as the criteria for which records in the MainTable I want to append a copy to in the ArchiveTable.
Basically I need all the CarIDNumbers in the UpdateTable because each time I want to append a copy of all of the records and after each process I will delete all the records in the UpdateTable
Please let me know if further clarification is needed.