auto number

[Aurora]

I am using Access 2003.
I need a column where the number increase by 1 for each new record. I
created the file as an "autonumber" type but can not remember how to make it
start with the number I want. Can anyone help me with this?

Aurora

 

[Jerry Whittle]

An autonumber will not work for your purposes. You can't really "set" an
autonumber. Also you can not be sure that the number will be sequetial. Also
it's possible to "burn" or "skip" an autonumber so that there will be gaps.

Probably the best way to do this is to use the DMax function +1 on a number
field on an event of a form such as Before Insert.