Description
Returns the next sequential number every time the passed value changes. This function can handle more than one value at a time.
Syntax
NEXTTRANSNUMBERN ( index, SourceField )
| Parameter | Description |
|---|---|
| index | The counter. A number between 0 and 10. |
| SourceField | The source field to check. If the value is the same as the previous row, then the next sequential number is returned. If the value has changed, then the number is reset to 1. |
See also