Appending only the records that do not exist

[dark11984]

I have table 1 that has 13100 records and table 2 that has 13000 records. Both these table contain the same information except table 2 has 100 more records.
I would like to append the 100 records only that do not exist in table 2 from table 1.
Is this possible?

 

[boblarson]

Use the UNMATCHED QUERY WIZARD to create the query for identifying the records you want and then go into the query in design view and change it to an append query.