title: DoCMD.RunSQL (UPDATE TABLE INCREASE VALUE POS)
body: <p>I hope somebody can helping with this question.
  I use bellow VBA code within an Access Database MdB.</p>
  <p>But now i need to know how to update the column Pos with 1,2,3,4,5,
  The default value is now for the column Pos zero.</p>
  <p>Example Result:</p>
  <p><a href="https://i.stack.imgur.com/hMOO9.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hMOO9.jpg" alt="enter image description here" /></a></p>
  <p>I use the current script now but i don't know how to add the + 1 value per record.</p>
  <pre><code>Public Sub DoSQL()
   
      Dim SQL As String
      
      ' Here i want + 1 for the pos in every next record....
  
      SQL = &quot;UPDATE TABLE SET Pos = 1 WHERE Box = 'UPDATE'&quot;
      
      DoCmd.RunSQL SQL
       
  End Sub
  </code></pre>