I'm looking for a way to create a rolling sum in a field. By that I mean first record amount is 49.40 sum is 49.40, second is 30.69 sum is 80.09(49.40+30.69) third is 41.09 and sum is 121.18(49.40+30.69+41.09) and on and on. I assigned a row number to me query to identify the first to last row. I searched forum for Rolling sum and didn't find what I was looking for. Is there a different term I could search for to get an answer.
SUM(column) OVER (Order By ...)Just found it. Thanks. Rolling Total. Appreciate your help.