title: How to create an AutoNumber field value in Access?
body: <p>I'm trying the following:</p>
  
  <pre><code>CREATE TABLE Table1
  (
      RecordNo autonumber, --error here!
      PersonId varchar(50),
      ...
  )
  </code></pre>
  
  <p>But, there is an error.<br>
  How can I build the correct query in Access?</p>