I would like to create a running sum in a column of my query. The query is currently set up with fields:
Yr Mth PSI # * Status
The PSI # is a Count field, which counts the number of records within each year and month by their creation date. The * Status has a criteria of "New" so that only new records are counted. The output of the query is currently:
Yr Mth CountOFPSI # * Status
--- ----- ------------------ ----------
2009 7 3 New
2009 8 4 New
2009 9 10 New
How can I add a running sum column to achieve:
Yr Mth CountOFPSI # * Status RunningSum
--- ----- ------------------ ---------- ---------------
2009 7 3 New 3
2009 8 4 New 7
2009 9 10 New 17
I think I can do this using DCount, but I don't know how to create the expression. The name of the table this data is based on is "Data" and the name of the Query is "Count_New"
Yr Mth PSI # * Status
The PSI # is a Count field, which counts the number of records within each year and month by their creation date. The * Status has a criteria of "New" so that only new records are counted. The output of the query is currently:
Yr Mth CountOFPSI # * Status
--- ----- ------------------ ----------
2009 7 3 New
2009 8 4 New
2009 9 10 New
How can I add a running sum column to achieve:
Yr Mth CountOFPSI # * Status RunningSum
--- ----- ------------------ ---------- ---------------
2009 7 3 New 3
2009 8 4 New 7
2009 9 10 New 17
I think I can do this using DCount, but I don't know how to create the expression. The name of the table this data is based on is "Data" and the name of the Query is "Count_New"