Update query with duplicate msg

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JOM - 16 Nov 2005 18:15 GMT

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?

Reply to this Message

KARL DEWEY - 16 Nov 2005 18:26 GMT

Your statements are confusing to me.

> it says you are about to append 12 records
> records that were supposed to be updated

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.

> 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
[quoted text clipped - 4 lines]
>
> Any reason as to why this could be happening?

Reply to this Message