G Guest Jul 14, 2006 #1 I am trying to create a field in a table that will auto number while skipping every 4th number. Like 1,5,9,13
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 Jul 14, 2006 #2 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?
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?
