<div>
In this particular case, the field I want to sort by (and would have to use as the comparison in the &quot;DSum()&quot; running sum method) is a prioritization score, which carries 14 decimal places, and still is not unique! (in fact, it is often duplicated! it is calculated in individual excel spreadsheets for construction &amp;&nbsp;maintenance projects, which I import &amp;&nbsp;merge) <br />
<br />
The other running sum method I know of (the &quot;Global Module&quot; one) is not my favorite, because of the need to initialize. &nbsp; &nbsp;<br />
<br />
I was hoping the Access Pivot Table was smart enough to do that. Excel will do it, I think?
</div>


In this particular case, the field I want to sort by (and would have to use as the comparison in the "DSum()" running sum method) is a prioritization score, which carries 14 decimal places, and still is not unique! (in fact, it is often duplicated! it is calculated in individual excel spreadsheets for construction & maintenance projects, which I import & merge)

The other running sum method I know of (the "Global Module" one) is not my favorite, because of the need to initialize.    

I was hoping the Access Pivot Table was smart enough to do that. Excel will do it, I think?

<div>
Here is a pretty good solution I found:<br />
<a href="http://www.tek-tips.com/faqs.cfm?fid=5268" rel="ugc">http://www.tek-tips.com/faqs.cfm?fid=5268</a>
</div>


Here is a pretty good solution I found:
http://www.tek-tips.com/faqs.cfm?fid=5268 [http://www.tek-tips.com/faqs.cfm?fid=5268]

<div>
<div class="content wysiwyg-content">
Hello - can you set up a column to have a running sum in Access Pivot Tables (2010)?<br />
<br />
If so, how?<br />
<br />
Thanks
</div>
</div>


Hello - can you set up a column to have a running sum in Access Pivot Tables (2010)?

If so, how?

Thanks

Running Sum in Access Pivot Table?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.