Append querr that only append new record

D

DLAM

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
 
J

Jeff Boyce

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.
 
Top