Auto number satrting from the value that i give in

O

Owais

Well the problem or say what iw ant to do is that i want to use the auto
number feature to start from a specific value that i give it and it should
carry that on from there.
Or is there any other way so that i can make it work like this e.g
record one:> customer id is 1009
nexst record :> customer id should be 1010
i mean the id should increment automatically like the auto number feature
works.. but the starting point must be defiend by me.
 
A

Arvin Meyer

Create an append query and append 1 single record with 1 less than your
desired number.

I should caution you that autonumbers are not the best choice of numbers
used for specific numbering schemes. They are only guaranteed to be unique
and can't be replaced once used.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
O

Owais

Hi Arvin.. thx for ur reply.. Well now one more thing how to append the wuery
and what should it say.. eg if my table has a column named id and it's
property is autonumber.
and secondly as u said u don't recommend this aproach then what is ur
recommendation.
 
A

Arvin Meyer

An append query like:

INSERT INTO MyTable ( ID ) SELECT 1009 AS Expr1;

I use an expression in the default value property of a text box like:

=DMax("[ID]","MyTable")+1

That way you can change the number as you wish.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top