If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Default number to the new record
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 |
#2
|
|||
|
|||
Default number to the new record
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 "sg" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
odd number font as default in Word 2002 | jcm | General Discussion | 2 | June 21st, 2004 07:09 PM |
the default value of zero in fields with a Number data type | Paul James | Database Design | 3 | June 19th, 2004 09:31 AM |
Job Number Match function??????? | Russ | Worksheet Functions | 3 | April 19th, 2004 06:51 PM |
Changing default number format in worksheets | John deChadenedes | Worksheet Functions | 0 | October 9th, 2003 05:52 PM |
negative number default | laura | Setting up and Configuration | 0 | September 15th, 2003 02:44 PM |