Incrementing number field in access

[dympna@crosslandtankers.com]

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

[Tom van Stiphout]

Re: Incrementing number field in access

On 12 Feb 2007 03:45:17 -0800, dympna@crosslan dtankers.com wrote:

This is a FAQ. Search at groups.google.c om, 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