Description
Returns the next sequential number if the passed value does not change, otherwise resets to 1.
Syntax
NEXTITEMNUMBER ( 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. |
Remarks
A null value (#NULL) or empty string may return unpredictable results.
Warning: Make sure that you only use NEXTITEMNUMBER once in any DTS file. Using it more than once can cause unpredictable results.
See also