Append query - only want to append new records

[Mandi]

Hello,

I have created an append query. How do I get Access to
only append records that aren't currently in the 'append
to' table (based on the field 'id')?

Thank you,
Mandi

 

[Duane Hookom]

Add the append to (target) table in the query and join to the source table
with joins that select all records from the source. Add a field to the query
grid from the target table and set the criteria to:
Is Null

 

[Mandi]

Thank you. I was adding a field to the query grid from
the source table - instead of the target table...