title: Access 2010 Update Query for a Multivalue Field Set Equal to Value of Other Table
body: <p>I have a database of U.S. Congressional information whereby I have <b>FirstName</b>, <b>MiddleName</b>, <b>LastName</b>, <b>District</b>, <b>State</b>, <b>Party</b>, etc. of each Congressman in the 112th Session of the U.S. House of Representatives and I want to add <b>Committee</b> information for each (i.e. what committee(s) they are on). I have a large table (called <b>StateCommittee</b>) of <b>District</b> | <b>State</b> | <b>Committee</b> as such:</p>
  
  <pre><code>Financial Services              5   NY
  Foreign Affairs                 5   NY
  Judiciary                       24  FL
  Science, Space, and Technology  24  FL
  Appropriations                  4   AL
  </code></pre>
  
  <p>that marks which committee is assigned to which district. I also made a field in my <b>Representatives</b> table called <b>Committees</b>, which is a multiple-value lookup field to another table I have called <b>List of Committees</b>. Ideally, I would like to create an <b>Update</b> query that generally "fills in" <i>[Representatives].Committees.Value</i> (the aforementioned multiple value field) with the appropriate <b>Committees</b> (ideally from the <b>List of Committees</b> table) when the two have identical district and state. So, ideally, it would look like this in pseudocode:</p>
  
  <pre><code>Update [Representatives].Committee.Value
  SET [Representatives].Committee.Value = [StateCommittee].Committee
  WHERE [Representatives].District = [StateCommittee].District And [Representatives].State = [StateCommittee].State
  </code></pre>
  
  <p>However, when I put into the Update query exactly the above code, Access produces the following error:</p>
  
  <pre><code>syntax operation error ".
  </code></pre>
  
  <p>Does anyone have any ideas as to what I am doing wrong or if what I want to do is not actually possible? Thanks so much!</p>