How do I over ride a auto number

  • Thread starter OVER WRITE AN AUTO NUMBER
  • Start date
O

OVER WRITE AN AUTO NUMBER

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
[email protected]
 
R

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
[email protected]> wrote in message
news:[email protected]...
 
Top