Auto number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Francis Cunningham, Jr. - 04 Mar 2005 16:45 GMT

Hi,

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

Frank

Reply to this Message

gls858 - 04 Mar 2005 17:50 GMT

> 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

Reply to this Message