How to Increment a number in Microsoft Access
Posted on 2014-01-02
I have a table with a field named TestNumber and I want to fill it with "20140001" and then as I add records I want to add the next record as "20140002" and so on. I would like to have the 2014 be entered from a year function but the 0001, 0002,0003 be entered as the next number in the list.
The 2014 could be a place I change in the code or if I need a table with parameters use that.
I have been trying several paths but so far nothing has worked like I wanted it to. Has anyone got a good method that I could had to either the field or to an add button to make this increment.
Thank you fg