Start AutoNumber at 0

[acent]

I'm wondering, is it posible to start the autonumber at 0 instead of 1? Or, better said, can I assign a record to have a value of 0? I know I can import the data as a way to force the starting point, but I'm just not sure if the autonumber can contain a value of 0.

"God is a comedian playing to an audience too afraid to laugh."
-- Francois Marie Arouet (Voltaire)

 

[fneily]

I assume you're using autonumbering for your primary key. You can just type a 0 there on a new record. When you display the recordset in a form, it will start with 0.

 

[PHV]

ALTER TABLE yourTable ALTER COLUMN yourAutoNumber COUNTER(0,1);

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

 

[Remou]

I wonder if you know that, having started at 0, there is no guarantee that the next number will be 1, or even that it will be positive, depending on your set-up?