Auto number will start from 10 not in 1

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

I have created a Data entry form wherein they enter outgoing faxes. They are
already in number 51775, which they call the reference number and they are
writing this manually in a book. They want that to be automated but they want
that the next number to appear is 51776.

I have been trying to make this work but i still end up with 1. I cannot
find within the help command any mention on how to solve this problem.

Can you please assist me in this. Thank you.
 
Hi Neil,

it is possible to start an autonumber field with another number then 1 (see
Access help), but it won't help you much. Whenever you enter a new record,
find out you make a mistake and restart, the autonumber that was created is
lost, and you have a "hole" in your numbering. A better solution in this
case is to create a normal number field - type long and then fill it with a
counter such as
myField = Dmax("myField","MyTable") + 1
or work with a separate numbering table.
 
Back
Top