Auto Number Question 1

[Rene1024]

Hi,

I would like to create a table with an autonumber field, but I would like the auto number to start at 2500.
How can I do this?

Thanks.

Rgds.

Rene

 

[striker83716]

First build your table as normal.

2nd build a second table with only 1 field in it, a number field. put in 1 record in this second table, the number 2499.

3rd build an append query off of the second tables, append to the 1st table autonumber field, run the query. this will put the number 2499 in the 1st table as the first record. Delete this record and you have now set the autonumber field to 2500.


Rob

 

[JeremyNYC]

Rene,

It sounds like you're probably laboring under the same false assumptions about autonumbers that many new Access developers get caught by. I've explained it so many times that I just put up a web page to save myself time. It's in the Developers' section of the website linked in my signature.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[gimenes26]

i`ve tried but still not working.. i have the same problem i want the autonumber to start at 3000...
any chance that u can explain it step by step?

 

[Golom]

Microsoft explains it step-by-step in this article

 

[PHV]

And the SQL way:
ALTER TABLE yourTable ALTER COLUMN yourAutonumber COUNTER(3000,1);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886