I am trying to add a new column to a table that would count the occurrences of a field change I.e.: field1 = 5 new column count = 1. Next record field1= 5 new column count = 2 , next record field1 = 8 new column count = 1 Is it possible to hold prior row value to test? Thanks in advance StuR feild1 new column 5 1 5 2 8 1 10 1 10 2
... View more