Append query - only want to append new records

  • Thread starter Thread starter Mandi
  • Start date Start date
M

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
 
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
 
Thank you. I was adding a field to the query grid from
the source table - instead of the target table...
 
Back
Top