Assuming I can create a variable (in this case the current record’s job number) can I populate the job number field in the next record with it?
Yes you can do that for example with thecombination of MAXROW() expression and Initial value. Check this article…
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |