accumulation totals

[Dez]

Hi I have columns of daily snow depths and I want to measure daily storm total an accumulation total and the number of days in the storm cycle, currently i only have the date and SnowDepth columns in my table for the last 30 years.

eg Date SnowDepth DailyTotal StormTotal StormDays
1-Jul 100
2-Jul 101 1
3-Jul 106 5
4-Jul 125 19
5-Jul 142 17 42 4
6-Jul 142
7-Jul 140
8-Jul 136
9-Jul 135
10-Jul 137 2
11-Jul 138 1
12-Jul 139 1 4 3
13-Jul 139
14-Jul 145 6
15-Jul 150 5
16-Jul 162 7
17-Jul 174 12 30 4
18-Jul 171
19-Jul 170
20-Jul 165
21-Jul 165
22-Jul 165
23-Jul 170 5
24-Jul 171 1
25-Jul 185 14 20 3