title: Update table setting the value of a field to the result of a query
body: <p>I have the following table(let's call it Sales) structure:</p>
  
  <p><a href="https://i.stack.imgur.com/t0aS1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/t0aS1.png" alt="Table Structure"></a></p>
  
  <p>What I would like to do is to fill the field "SalesID" with values resulting from a query I have created in the same DB. This query reflects the table structure so I was thinking to connect the two using the ID.</p>
  
  <p>Basically, I am trying with scripts of this forms:</p>
  
  <pre><code>UPDATE Sales 
  SET SalesID = ( SELECT  SalesIDCalc FROM (SELECT Sales.ID, Sales.[Email Address], Sales.[Points], IIf([Points] &gt;80,"Super","Normal") AS SalesIDCalc FROM Sales) AS q 
  WHERE Sales.ID = q.ID);
  
  </code></pre>
  
  <p>but I am nowhere near the solution. Do you have any idea on how to proceed?</p>
  
  <p><strong><em>EDIT</em></strong>: Now I get the Error 'Operation must use an updateable table'</p>