Can someone please help me with a vba code that will add numbers to a table field. I have a table that will have a list of records that are added throughout the month and the contents will be moved to another table at the end of the month. I would like to use VBA to add numbers to each record before the records are moved and the next number stored so that it can be used again when the process is generated.
I hope this can be done. Thanks in advance.