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 ...

The easiest way is probably to create an Access VBA public function which takes the date parameters, queries the table and returns the appropriate count; and call this function within the UPDATE ...