I have a file of five fields containing a number of records.
I want to update the value of field 5 on a second record where the second record matches the first record for the first three fields, but where field 4 is the opposite (negative) value of field 4 on the first record.EG:
12345678, 23456, AA, 100.00, XXX
12345678, 23456, AA, -100.00, YYY
I want field 5 on record 2 to be updated to XXX.
Can anyone help?
April 14, 2009 8:44 AM
April 14, 2009 3:33 PM