Sequential Numbers For Records

[AccessTexas]

Need a sequential number on report. Have an unbound text box and set it to list a running sum over group. The twist is that I'd like to have it start with an assigned starting number [Starting Number] and then add 1 to each subsequent record. It works for the first record but then the next record is last value + [Starting Number]. Basically it is a check run where I would list the starting number and the report would do the rest.

 

[AccessTexas]

I found a way to accomplish the task. It is crude but works for my needs. I put a text box in the header that prompts for the starting check number minus one, and property of no for visible. In the detail I also hid the textbox that has the running sum. Next to that I have a text box that adds the starting number to the text box with the running sum and that gives me the right number I was looking for.

 

[jdraw]

Good stuff, and thanks for describing the solution.