I think you should read and ponder this discussion.
http://www.experts-exchange.com/Databases/MS_Access/Q_21024460.html
Bob
Hi
I am using a access database and would like to know if it is possible for the first cell in each row to have an auto number added to it (not a primery key though)?
ie. if I had ten rows, the first cell in each row would show 1,2,3,4 etc. but if I deleted row 3, all the rows would then re-number, so I'm still left with 1,2,3,4 etc.
Many thanks
Happy.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic