Hello,
I want to update or add new records on a table from another table with out it duplicating what do I use and how? Updating primary keys

Daniel

Try this Microsoft Support article, Updating and Appending Records in One Update Query (Q127977): http://support.microsoft.com/default.aspx?scid=kb;en-us;q127977
HTH,
David R