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
|
|||
|
|||
Number Increments
How can I add a field that increments to an existing table. I know I can
use the auto num but that starts at the number 1 and I want to start my numbers at 100, 101, 102, and so on. Any suggestions? Thanks, Chris |
#2
|
|||
|
|||
Number Increments
There a couple of things you can do and it depends on what you are going to
use the nubers for as to the best approach. You could use an autonumber that starts at 1 and add 100 to it in your query to give you the numbers you said you wanted. You could add a number field to your existing table and insert the desired numbers. Create a copy of the table structure with an autonumber field and append the existing table. The autonumber field will accepts the number and continue from the last number as records are appended. "Chris" wrote: How can I add a field that increments to an existing table. I know I can use the auto num but that starts at the number 1 and I want to start my numbers at 100, 101, 102, and so on. Any suggestions? Thanks, Chris |
Thread Tools | |
Display Modes | |
|
|