Hi, I am trying to produce a field in a query that gives the running total, but then resets if there is a zero.
So for the table below, i would like to produce the field Wins in a Row
Date- Team- Win- Wins in a Row
29-Oct-06- Liverpool- 1- 1
12-Nov-06- Manchester- 1- 1...