I added WhilePrintingRecords; to the first formula, but count1 is still displaying as 0 in the third formula.

I have used Running Totals often, and they work fine, but the reason I am doing it this way is because I do not want to display the variables from running totals, but rather I want to run them through a formula first and have no bloody idea how to do that, as those variables don't seem to be declared at all. That is why I am going with the 3 formulas - so I can control the scope and usage of the variables.

If you know how to write a formula using the variables created in Running Totals, that would be great. Thanks!




Edited by NedSchneebly - 13 Aug 2009 at 2:52pm

Hmmm...I only use shared, just because they have the largest scope.  I too was under the impression that the only difference between Global and Shared was that the Shared could be seen in subreports.