Appending to table if content doesnt already exist

S

Stuart

Im trying to take records from one table to another only
if a value in the record being transfered doesnt already
exists as a vlaue of an item in the table, is this
possible im having a few poblems trying to do it

Cheers

Stu
 
J

Jeff Boyce

Stuart

One approach would be to create a Unique Index on the receiving table, on
the field(s) that you don't want duplicated.

Then, when you run an append query, Access will not add a row that would
duplicate those fields.
 
Top