title: Unable to update table via SQL query in Access
body: <p>Not sure if I am making a mistake in using SQL to update a table. </p>
  
  <p>I want to update some data in an existing table but it executes without updating.</p>
  
  <p>Table Field names: </p>
  
  <ul>
  <li>[Service Aquired on]</li>
  <li>[Next Service due on] </li>
  <li>[Total Amount Received(cr)]</li>
  </ul>
  
  <pre class="lang-vb prettyprint-override"><code>Dim sao As Date
  Dim nso As Date
  Dim tap As Currency
  
  sao = Nz(Me.Service_Aquired_on.Value, 0)
  nso = Nz(Me.txt_NSDO.Value, 0)
  tap = Nz(Me.txt_tatp.Value, 0)
  
  DoCmd.RunSQL "UPDATE Service_MasterData SET([Service Aquired on],[Next Service due on],[Total Amount Received(cr)])" &amp; "VALUES ('" &amp; sao &amp; "', '" &amp; nso &amp; "','" &amp; tap &amp; "')"
  </code></pre>
  
  <p>Kindly assist</p>