How do I Increment an auto numbered field with value > 1

G

Guest

I am trying to create a field in a table that will auto number while skipping
every 4th number. Like 1,5,9,13
 
D

Douglas J Steele

You can't change the behaviour of the Autonumber field in Access: it's
either sequential (increasing by 1), or random. No other choices.

To get what you want, you'll have to write your own code to keep track of
the value and increment it as desired.

However, why do you need this? What purpose does it serve to have the field
skip values?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Entry Form and Auto Number ID 2
Auto numbering 1
Simple Ref number for a form 2
Auto number in an existing table 4
Primary Key Field (Auto Increment) is Creating Duplicate Record Va 10
Auto Numbering 5
Not use autonumber 6
Auto Increment Field or Identity Field In MS SQL Server 0

Top