|
| 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
July 27th, 2004, 04:54 PM
|
|||
|
|||
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
July 27th, 2004, 05:48 PM
|
|||
|
|||
|
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 |
Linear Mode
