Append only new records with an append Query

[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

 

[KARL DEWEY]

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));