Help numbering rows.

[rmg540]

Hi.

I have to add numbers to a table starting with 999993425541.and incrementing for each row after.
How can I go about doin this?
Thanks

 

[Atomic Shrimp]

Does this include the numbering of new records that are added to the table after the existing ones have been numbered?

 

[Dennisk]

Although it is possible to start an auto number from any value, it does not guarantee to generate consectutive numbers only unique.

If this number is to be exposed to the users then the best way forward is to gnerate your own numbers. The question is answered at least once per week on this forum, so search for autonumber.

 

[Mike375]

Here is a recent thread that covers it.

http://www.access-programmers.co.uk/forums/showthread.php?t=166303

But as Dennisk said there are many threads as it pops on a regular basis and you are bound to find one that is suitable.