Description
Returns the next sequential number every time the passed value changes.
Syntax
NEXTTRANSNUMBER ( SourceField )
| Parameter | Description |
|---|---|
| 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