Default number to the new record

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
 
S

sg

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top