<div>
Many thanks s46<br />
<br />
Peter
</div>


<div>
no probs - glad to help.<br />
<br />
s46.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am working on a MS Access database, the current value is 8870, the number range 9000 is used for internal numbers so what I want to do is as I reach the 8999 mark is to jump &nbsp;6000 and continue the autonumber from 15000 onwards, what would be the best way to do this, and can I do it without insert blank records?<br />
<br />
Many thanks<br />
peter
</div>
</div>


Hi,

I am working on a MS Access database, the current value is 8870, the number range 9000 is used for internal numbers so what I want to do is as I reach the 8999 mark is to jump  6000 and continue the autonumber from 15000 onwards, what would be the best way to do this, and can I do it without insert blank records?

Many thanks
peter

Adjusting the autonumber in MS Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.