Access Compare records in same access table

[Judith Bonds]

I need to compare field "doc_num_cd" in my table "Parts" to find any duplicate document numbers. If a duplicate is found I need to compare the field "last_update_dte" and move the record with the oldest date to a table "Parts_History".

I think I have the compare code:

SELECT *

FROM Parts

WHERE Doc_Num_Cd IN (SELECT Doc_Num_Cd FROM Parts GROUP BY Doc_Num_Cd HAVING COUNT(Doc_Num_Cd) > 1)