Update MSAccess table from another Access table using SQL ...

I'm not sure your select statement returns only one row. If you want to perform an update on a table using a select statement for assignment, you must ...

stackoverflow.com