report running sum 1

[swtrader]

fields on report [pmt], [amt_due].

I'm trying to put a running sum [baldue](unbound text box) in the detail section.

I've tried various things, including: =SUM([amt_due]-[pmt]); Running Sum set to All.

The [baldue] is not correct.

thank you.

 

[PaulBricker]

Well, first you normally would not use the Sum() function and the Running Sum reference on the same data. First, try removing the Sum() function from your control source.

=([amt_due]-[pmt])

and set the running sum to over all.
If that doesn't get you there, then post back with specific problems and we'll see what we can do from there.


Paul

 

[swtrader]

Thanks, Paul --

Once I was sure I had the right formula (that you provided), I could look for something else. Was as simple as having a bunch of nulls in my [amt_due] data.



swtrader
-- If you don't know where you're going, you'll always know when you're not there.

 

[AslamHussaini]

Hi Dear, I have a problem when i used sum function as control source it's running well but when used in vba module
I got error "Sub or Function not defined"
Kinldy help me and slove this problem