Sorry, I found where the problem was....I know it was obvious but it was killing me...

Of the 30,000 rows of the table with the problem, two of them became duplicated records (with the update), so the query aborted everytime. I made a temporary workaround (manually changing only those 2), so it could not affect the query.

Sorry again, still learning from the experts...

Great forum!

Thanks.