How do I get consecutive numbers into a table based on how many records are imputed. Example of consecutive numbers: 1, 2, 3, 4, 5, 6, etc.
I'm pulling data from another access database and imputing it in a table. The table has a number associated with each entry. This is done automatically when you enter a record from a form. When I'm imorting information I want to be able to give it a beginning number and have add a consecutive number for each transaction that is entered.
I tried using the autonumber but I want to be able to enter a beginning number instead of having it assign one for me.
I do not have a clue how to even start this so any help would be appreciated.