Appending to table if content doesnt already exist

  • Thread starter Thread starter Stuart
  • Start date Start date
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
 
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.
 
Back
Top