The previous picture displays the running balance of all of the transaction records. The Balance field uses the same controlsource as the Amount field, but the Running Sum property for Balance is set to Over All. (The choices for this property are Over Group, Over All, and No.) At first glance, anyone could be fooled that this data is accurate, but compare the first report picture with the second, and you can see that the report is significantly incorrect. Although the Running Sum property can perform the task of adding the previous value to the current value, it cannot incorporate the starting balance from the top of the report. Without the use of the starting balance, the ending balance will always be incorrect.

0 0

Post a comment