Append querr that only append new record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

how can I use my append query to append only the new record ( Which haven't
append before) to the append table.

Thanks

DLAM
 
One approach is to set a unique index on the underlying table. That way,
when the append query runs, it won't be able to append a record if the
fields in the index you added match an existing record.
 
Back
Top