update query updating more records than there are in the database

[KLRoss]

I am doing an update query on a database that has 2,589 records in it. When I run the update, it says it is updating 2,665 records. The update query is:

UPDATE Athena LEFT JOIN Providers ON Athena.[HT Project Code] = Providers.[Project Code] SET Athena.OrgRefID = [Providers]![OrgRefID]
WHERE (((Athena.OrgRefID) Is Null Or (Athena.OrgRefID)=""));

The Athena table has 2,589 records in it and the Providers table has 319 records in it.

Any idea on why it is trying to update 2,665 records and where are the additional 76 records?

[ranman256]

Some queries ,due to their joins, will do that.
It will update the same record more than once, but the same value.
So, nothing to worry about.