Hi, I'm trying to create a module or some type of formula that will prompt the user to enter a beginning check number: i.e. 1118172 and then update subsequent rows in a table with sequential number including that first number, incremented by 1 for each subsequent line.
Here is an example...
Starting Check Number: 1118712
First three rows in the table would have:
I have a column in a table labeled: RFCK#. I would like to use some form of a parameter value to enter the first check number and then cascade down, as I described above. I've tried many things, but it is just getting frustrating.
Any help on this would be greatly appreciated.