title: Update Query from a Lookup Query
body: <p>I have a spreadsheet that I am converting to an Access DB.  I have a column of typed out customer names that I want to replace with the appropriate customer number from our accounting system.</p>
  
  <p>I have created a table with the customer info, and a query that shows what ID needs to be inserted into the source data.  What I'm looking for is:</p>
  
  <pre><code>UPDATE tblStarting_Data
  SET CustomerID=x
  WHERE TEMPCustomer=y
  </code></pre>
  
  <p>Where X and Y come from qryIDPerCustomer.</p>
  
  <p>Can I use a loop?  How do I reference another query?</p>