title: Update A multi-valued field in Access
body: <p>I have created a lookup table in Access to provide the possible values for a column. Now I need to update this column with the data it had before I converted the column. I am unable to figure out a SQL Query that will work. I keep getting the error "An UPDATE or DELETE query cannot contain a multi-valued field." My research has suggested that I just need to set the value of the column but this always updates 0 records:</p>
  
  <pre><code>UPDATE [table_name] SET [column_name].Value = 55 WHERE [table_name].ID = 16;
  </code></pre>
  
  <p>I know this query will work if I change it to update a text column, so it is definitely a problem with just this column.</p>