Append Query Question

[DavidW]

I made an append query to import a list from table 2 into table 1, is there
a way to check the list in table1 and compare it to table 2 and only import
the records that are not in table 1

 

[Vicki]

Create an unmatched query using Table 2 and the append
query (in that order). If you change it to be an append
query after it's created it will automatically add any
records missed the first time thru