Hey guys,
So I feel like this should be such a simple task, but I can't figure it out. I just want a column that automatically numbers itself sequentially. I don't want the AutoNumber format, because if I end up deleting the last row, when I add a new row I want it to use the same number the last row had before being deleted.
I'm guessing I need to make a column using a calculation and somehow have it increment every time a new row is added, but I can't find any function in Access to do this.
Thanks for the help.