MS Access Autonumber – How To Take Control And Change The Starting Number

MS Access Autonumber – How To Take Control And Change The Starting Number

Using the MS Access AutoNumber data type field is the first step to keeping the data integrity of your Access database under control stopping end-users from mismanaging key records.

However, when setting the MS Access Autonumber data type to increment, it starts with the value of 1 incrementing by one for each new added record. But what if you wanted to start at 1000? Instead of me creating a quick video tutorial to show you how, let’s ask Paul to demonstrate it below in this 3 minute video…

MS Access Autonumber – How To Take Control And Change The Starting Number

So you now know a little more about MS Access Autonumber data types unique properties having seen it demonstrated in this video. You will need to know something about append queries which is one of the four action queries Microsoft Access offers.

There is another property value available other than ‘Increment’ option which is required for this technique to work and that is called ‘Random’.

Look out for my next post on how to create your own random unique value which can be edited and controlled using the ‘Default’ property for a new record.

In the meantime, I welcome your comments below and any questions you may have.

This entry was posted in MS Access, Queries, Tables and tagged , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.