Update query says updating but nothing updated (1 Viewer)

I have a very simple update query. I have a table [TAM Adop Bonus], which has a number (double, standard, 2) that relates to a bonus rate (as a %, double, percent. auto). My query should look up the value in a field and update the rate into the update field based on criteria. It runs, says its updating the expected number of fields, but nothing actually updates.

Been staring at it and changing number formats for 2 days now. Need help!

Here's the query, I've verified that all number formats in the fields are matching, and I get no errors.

UPDATE TAM_CommissionTable_Quarter LEFT JOIN [TAM Adop Bonus] ON TAM_CommissionTable_Quarter.AdoptionRate_Change = [TAM Adop Bonus].Adop_Rate_Change SET TAM_CommissionTable_Quarter.AdoptionBonusRate = [TAM Adop Bonus].[Adop_Bonus_Rate]
WHERE ((TAM_CommissionTable_Quarter.Quota_Attainment_Pct)>0.745);

Run and it says "You are about to update 21 rows".

Nothing changes.

Any suggestions?

Hi. Welcome to the forum. What happens if you use an INNER JOIN instead? Just curious...

0 fields updated....

I ended up using a switch function. that resolved it.

ascrazzle said:

0 fields updated....

I ended up using a switch function. that resolved it.

Click to expand...

Hi. Glad to hear you got it sorted out. Good luck with your project.