Number Increment

[xion.hack]

Hello. I have a table with 100 records. I want to make a new column, called Receipt number, but I want the first field to start with 21 and to increment with the other fields that already exist finishing in the 121. I don't have a form and I don't want to make one. Is there another way to do it? Thanks!

 

[Mike375]

Type 21 into the first record and then use the downward arrow to go to the next record and then type 22 and then hold the arrow down and it should continue to fill each record with incrementing numbers.

 

[ACMAIN_CHM]

hi Xion.Hack,

how about your Table structure ? we did not know wether there is already a auto-increment fields or other PK in your Table.

usually you can add a column with AutoNumber datatype and it will start from 1. if you want to begin with 21, you need create a another table with same structure like you current table, and then insert the first 20 blank records, then insert all the records to this new table, delete the old table, rename the new table.

best regards
ACMAIN