Append querr that only append new record

[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

 

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