I am trying to count records in a running sum fashion in a QUERY and for the records to restart when the field changes. I tried DCount without success.

ie. if a field contained the following data
Code Running Count
C101 1
C101 2
C103 1
C103 2
C103 3
C104 1
C104 2

Thanks

Look at attachment (Dok2, Word),
adapt it as you need.