Default number to the new record

  • Thread starter Thread starter sg
  • Start date Start date
S

sg

Hi,
I have a table name hardware, with field tag number etc. I want the tag
number starting with 2001, and the new record will be 2002....., which means
it would be automatically filled in with the next number. How can I do this
in design?

Thanks,
Sarah
 
In another words, if I can use autonumber on field tag number, can I start
with my own number instead of 1. Value will increase 1 every time the new
record added.

Thanks,
sarah
 
Back
Top