Microsoft fixed a known issue occurring for Update queries in Click-2-Run and Windows Installer (MSI) editions of Access 2016, triggering errors when accessing databases and breaking functionality for ...
Your query also has a stray # symbol. If you stop putting spaces in your table/field names you won't have to put brackets around them. If you didn't use the super convenient DSum, you'd have to create ...