Microsoft Access Expert 17 Video:2 at the 15:19 time index you ran into the Duplicate Out Put Destination Error for ToBeArchived field. you later explain that in the Append Query each field needs to be listed separately if you are using one of the fields as Criteria. I have found in my working with Access that by removing the Append To reference to the duplicate field (The one used for Criteria) it works just fine with no error