How do I change the auto number to begin with the number I want?

G

Guest

I want to create an auto number field that begins with a number other than
zero. I have followed the help instructions for an append query and it
changed only the first record. Each new record did not follow the new
numbering sequince.

Thanks for any help offered.

Michelle
 
A

Allen Browne

Using ADOX, you can set the Seed and the Increment properties of the Column
in your Table in the Catalog.
 
A

aaron.kempf

allen

wow thanks!

any way to do this in pure TSQL if you were doing ADP?

-aaron
 
A

Allen Browne

Give it a try, Aaron.

From memory, you can assign the Increment when you CREATE TABLE, but I don't
think I ever tried to do it with an ALTER TABLE statement.
 
A

aaron.kempf

yeah i want to use it for BIGINTS where i have the first 5 digits 50805
-- aka the date.

so i want my PK for this huge table i've got to be 5080500000132431 or
something along those lines.. and then for tomorrow 508060000000000001

etc
 

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

Similar Threads

auto number in query 1
matching Auto-number (primary key) to Record number 6
Append Table - Auto Number Problem 3
Data Entry Form and Auto Number ID 2
changing start value in the auto number 4
auto number index snafu 6
Auto number in an existing table 4
How do I set up a unique number? 1

Top