Attached is an MS Access 2019 database. I'm hoping someone can download and let me know why I cannot update the OrderImports table. See update query. It appears the values match, but will not update.
However, if I manually cut-n-paste the values from ShipCodes into OrderImports, it would update.
I must be missing something simple.
Thanks!