how to change primary key's data

[Dennis]

( sorry about my english )

in the form primary key as my order number( auto number start 1 then
2,3,4,.......

I have 1 problem when 2003 end then come up 2004 so the order number
still following the auto number.But i want the order number start from
number 1 then goes 2,3,.......,,, when the years of 2004 come up ?

any help please ...

 

[Jeff Boyce]

Dennis

Autonumbers are ... autonumbers. They provide a unique (usually) row
identifier. They are NOT guaranteed sequential. They are NOT fit for human
consumption. They are NOT re-settable for each year.

If you need an ID number that is guaranteed sequential, and that you can
reset each year, you'll have to create your own. Check Google.com and the
mvps.org websites for ideas about "custom autonumber".

Good luck!

Jeff Boyce
<Access MVP>