Append only new records with an append Query

  • Thread starter Thread starter ram
  • Start date Start date
R

ram

Hi to All,

I would like to append only new records to a table based on a report number.
I did use John Version suggestion of createing an unmatched query which gives
me the new records. However when it appends the data there is no report
number included. I think it's because in the criteria the report number needs
to be null.

Can someone help me combine the unmatched query with the append query.

Thanks for any help
 
Try this --
INSERT INTO [6600 Course] ( COURSE, BUILD, SET )
SELECT [6600 EMP].*
FROM [6600 EMP] LEFT JOIN [6600 Course] ON [6600 EMP].Lname = [6600
Course].Lname
WHERE ((([6600 Course].Lname) Is Null));
 
Back
Top