Update query with duplicate msg

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to do an update query but when I run it it says double the number
of records in my table and when it updates the information, it updates the
required records with the same record ie I have about 6 records in my table,
it says you are about to append 12 records when i open the target table the
records that were supposed to be updated have the same record but are
supposed to be different.

Any reason as to why this could be happening?
 
Your statements are confusing to me.
it says you are about to append 12 records
records that were supposed to be updated
Click to expand...

Are you appending or updating?

If you have a key field and the records have the same value in that field
they will not append as they would be duplicates which is not allowed.
 
Back
Top