AutoNumber Again

  • Thread starter Thread starter AMF
  • Start date Start date
A

AMF

I have a field called Project #, I am needing to set the
first record to a certain number, let's say 4500. I need
to know how to set that record to that number and tell it
to increase by 1 for every new record added after that.

Thanks
 
AMF said:
I have a field called Project #, I am needing to set the
first record to a certain number, let's say 4500. I need
to know how to set that record to that number and tell it
to increase by 1 for every new record added after that.

Thanks
Click to expand...

Take a look at the reply from Rebecca to your prior message. What you are
planning is almost certainly a bad idea. If you need controlled,
predictable numbers, write your own function, don't use autonumber.
 
You should not use Autonumber for this purpose. You can't control the
sequence. You can develop gaps in the sequence that you can never recover.
On my website (see sig below) is a small sample database called
"AutonumberProblem.mdb" which illustrates one way to do this.
 
Back
Top