title: sql update table - statement not working
body: <p>I have the below statement in my VBA:</p>
  
  <pre><code>DoCmd.RunSQL "UPDATE customer SET Status = 'Premier' WHERE customer_id = 41308408 AND location IN ('London','New York') AND Status = ''"
  </code></pre>
  
  <p>which is meant to update a table called "customer". I can see in my table there are about 20 entries where the customer_id is 41308408 (i.e. if i filter the column for that value), with the location being either London or New York for each entry. The Status column is blank for each of these.</p>
  
  <p>I execute the above code, and it compiles OK, but it says "You are about to update 0 rows". I would be expecting that to be 20, as per above. Any ideas?</p>