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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append if Not Exist 4
conditional appending through append query 1
appending new records to a table with a compound primary key 9
Append Query: SQL to add a new record? 7
data append & overwrite by 1 step 4
conditional appending 1
Append Query - key violation - no duplicates, records exist in par 4
Preventing duplicate entries with an Append Query 3

Back
Top