I need to place a new/change flag or autonumber count in a new field when the word REV appears for the second or more time in a Change Log table.
This flag needs to be place in a load script so other calculations can be done.
Below is how the output should look. Any help or ideas would be great.
Example: Change Log Example with (new field)
Invoice #1, Detail ID#1, Type=REV, (new field) = 1 or New
Invoice #1, Detail ID#1, Type=OTHER, (new field) = 0
Invoice #2, Detail ID#36, Type=REV, (new field) = 1 or New
Invoice #3, Detail ID#44, Type=REV, (new field) = 1 or New
Invoice #3, Detail ID#45, Type=OTHER, (new field) = 0
Invoice #3, Detail ID#53, Type=REV, (new field) = 2 or Change
Invoice #4, Detail ID#55, Type=REV, (new field) = 1 or New