Running Sum in Query for Count Field

Joined
Sep 30, 2009
Messages
1
Reaction score
0
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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top