How do I over ride a auto number

[Guest]

I have created a table and on the left hand side each customer has a number
however I don't want the auto number to start from "1" I want it to start
from 20051......and onwards.

HELP !

Jo
(e-mail address removed)

 

[Rick B]

Do a search - asked and answered frequently.

Short answer is that autonumbers should not be used if you care about the
format of the number. In your case, an autonumber is not appropriate.
Instead, code should be used to find the highest number and increment it.

Read the previous posts on the topic for more details.

--
Rick B



"OVER WRITE AN AUTO NUMBER" <OVER WRITE AN AUTO
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Allen Browne]

See:
Set AutoNumbers to start from ...
at:
http://allenbrowne.com/ser-26.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

"OVER WRITE AN AUTO NUMBER" <OVER WRITE AN AUTO
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Joseph Meehan]

I have created a table and on the left hand side each customer has a
number however I don't want the auto number to start from "1" I want
it to start from 20051......and onwards.

HELP !

Jo
(e-mail address removed)

I suggest you follow the advice of Rick. Don't and you will be sorry in
the future. Autonumber are not for human consumption.