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

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