Number Increments

[Chris]

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

 

[Guest]

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.