moving records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables: tblExisting and tblModify. I need to transfer the records
from tblExisting to tblModify only if the records/data is not in tblModify.
I tried using an append query but I'm not getting the results I would like.

When I hit the cmdModify on frmExisting it opens up frmModify.
 
I am assuming that you have some sort of ID field. If that is correct use a
query like this

INSERT INTO tblModify(ID, Text1, Text2)
SELECT tblExisting.ID, tblExisting.Text1, tblExisting.Text2
FROM tblExisting LEFT JOIN tblModify ON tblExisting.ID = tblModify.ID
WHERE tblModify.ID Is Null
 
Back
Top