title: How to update ms access database table using update and sum() function?
body: <p>I have Two tables in my access database </p>
  
  <ul>
  <li>table1(ID,productname,qunatity,remainder)  </li>
  <li>table2(ID,productname,sales)</li>
  </ul>
  
  <p>these tables are related together using "product name" ,How can I update"reminder" from table1 with the value of "quantity form first table - Sum(sales) from second table"</p>