I think you should read and ponder this discussion.
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.