I'm copying data from my primary table to my archive table as part of an automated process. This was working but now the archive tables has got a bunch of key field values that duplicate what is in my main table. I need a query to compare these tables and find key values that are duplicated between tables. Then to change the archive table to an unused number. I can manually manually fix the problem by adding a bunch of 1's to the number. For example:
Steps_ID from 776182 to 1111776182
I'm looking for a query that could do that.
This is a simple query of the archive table and the field that I'm interested in:
This is the main table and the field to compare to the archive table