By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,336 Members | 2,315 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,336 IT Pros & Developers. It's quick & easy.

Incrementing number field in access

P: n/a
HI I am trying to create a number field that will create a unique
incremented number each time a record is added to the database via a
form. but I want that number to be in sequence and start from my
specified number.
I have tried the help in access and used the autonumber and the append
query to assign a specific number for the autonumber to start from,
but the problem that i get is when I add more than one record, the
next auto number that I get is not in sequence to the previous one, it
should be plus one.
There is no data is this database currently...

Thanks in advance

Feb 12 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 12 Feb 2007 03:45:17 -0800, dy****@crosslandtankers.com wrote:

This is a FAQ. Search at groups.google.com, and you will get many
answers.

-Tom.

>HI I am trying to create a number field that will create a unique
incremented number each time a record is added to the database via a
form. but I want that number to be in sequence and start from my
specified number.
I have tried the help in access and used the autonumber and the append
query to assign a specific number for the autonumber to start from,
but the problem that i get is when I add more than one record, the
next auto number that I get is not in sequence to the previous one, it
should be plus one.
There is no data is this database currently...

Thanks in advance
Feb 12 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.