title: Removing values from a multivalue field in Access
body: <p>I have a table called Users with a multivalue field named Area. I am creating a simple SQL statement that simply deletes an area designated to a single user. <em>In the below example: Removing area "G1" from the user with a badge number of "123".</em> </p>
  
  <p>Here's my SQL Statement:</p>
  
  <pre><code>DELETE Users.Area.Value
  FROM Users
  WHERE (((Users.Area.Value)="G1") AND ((Users.badgeNumber)="123"));
  </code></pre>
  
  <p>This somehow manages to result in an <em>Enter Parameter Value</em> dialog box. After double checking, all the parameters should be entered correctly. In fact, changing DELETE to SELECT creates a successful SQL statement.</p>
  
  <p>Looking at the Microsoft help page, I found <a href="http://office.microsoft.com/en-us/access-help/using-multivalued-fields-in-queries-HA010149297.aspx#BM9" rel="nofollow">this example</a>. </p>
  
  <pre><code>DELETE Issues.AssignedTo.Value
  FROM Issues
  WHERE (((Issues.AssignedTo.Value)=6));
  </code></pre>
  
  <p>This removes a value from the entire database. I'd like to remove the value from just a  single user.</p>
  
  <p>So now I am bit lost. Any help you can provide would be appreciated. Thanks.</p>