G
Greg
Hi All,
Consider the following sample table and values:
Field1 Field2
______ ______
A
A
A
A
B
B
B
I would like to loop through the records so that where the Field1 value is A,
Field 2 values are updated to 1, 2, 3, 4. Where the Field1 value is B, the
Field2 values become 1,2,3.
I'm looking to update a sequence number field in a table with 30,000 records
that follows the above pattern and re-starts the sequence number from 1 when
it hits a new Field1 value.
Thanks for the help.
Greg
Consider the following sample table and values:
Field1 Field2
______ ______
A
A
A
A
B
B
B
I would like to loop through the records so that where the Field1 value is A,
Field 2 values are updated to 1, 2, 3, 4. Where the Field1 value is B, the
Field2 values become 1,2,3.
I'm looking to update a sequence number field in a table with 30,000 records
that follows the above pattern and re-starts the sequence number from 1 when
it hits a new Field1 value.
Thanks for the help.
Greg