What can I do so I can edit the autonumber

[leeboycymru]

I have a client that I set up a database for him, and it runs fine and basically he has put old stock in and it comes out on top of the newer stock because of the autonumber id.

Can i do something in access that will allow me to edit the autonumber value and save it, so I can get the older stock back under the newer stock.

lee

 

[Remou]

Do not sort by the autonumber, sort by a suitable field such as a date. It would be possible to change the autonumber, but it is not a good idea as it leads to thinking that the autonumber means something: it does not, it is merely unique. The user does not need to see the autonumber.

 

[leeboycymru]

Hi there Remou,

Yes I thought about it and did what you said. I took a unique number on the title of the products and used that instead.

Works fine now.

cheers

Lee