Auto number

[Guest]

Hi,

Is there a way to have the data type 'auto number' in my table to start at
100 instead of 1

Frank

 

[gls858]

Hi,

Is there a way to have the data type 'auto number' in my table to start at
100 instead of 1

Frank

Check here maybe this will help:

http://www.microsoft-accesssolutions.co.uk/reset_autonumber.htm

If your planning on using this number as an Invoice number
or some other sequential numbering function that is not it's
intended function. It would be best to use another method. I
can't tell you the procedure of getting a field to increment
I'm sure there are others here that can.

gls858