INSERT INTO TableB (ID, Field1, Field2, Field3)
SELECT ID, Field1, Field2, Field3
FROM TableA
WHERE TableA.ID NOT IN (SELECT DISTINCT ID FROM TableB)
--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)
"Omi" wrote in message
...
I want to append records to tableB only when the key field in tableA does
not
match the key field in tableB