Need help with subreport/running sum

[EManning]

Using A2K. I've got a report/subreport that looks like the following:

<main report>
Account AAA Beginning Fund Balance: $10,000

<subreport>
"Expense" "Total" "Balance"
Expense #1 $4,000 $6,000
Expense #2 $50 $5,950
Expense #3 $100 $5,850
....and so on...

"Balance" is computed by subtracting "Total" from the previous
"Balance".

I'm not sure how to set "Balance" up in the subreport. Do I use a
running sum? If so, how?

Thanks for any help or advice.

[Marshall Barton]

EManning wrote:

>Using A2K. I've got a report/subreport that looks like the following:

<main report>
Account AAA Beginning Fund Balance: $10,000

<subreport>
"Expense" "Total" "Balance"
Expense #1 $4,000 $6,000
Expense #2 $50 $5,950
Expense #3 $100 $5,850
...and so on...

"Balance" is computed by subtracting "Total" from the previous
"Balance".

I'm not sure how to set "Balance" up in the subreport. Do I use a
running sum? If so, how?

Add a hidden text box (named txtRunExp) with control source
set to the total field and set its Running Sum property to
Over Group.

Then add a visible text box (named txtBalance) with a
control source expression like:
=Parent.txtBeginningBalance - txtRunExp

--
Marsh

[EManning]

On Jun 11, 4:01 pm, Marshall Barton <[e-mail]:

EManning wrote:

Using A2K. I've got a report/subreport that looks like the following:

<main report>
Account AAA Beginning Fund Balance: $10,000

<subreport>
"Expense" "Total" "Balance"
Expense #1 $4,000 $6,000
Expense #2 $50 $5,950
Expense #3 $100 $5,850
...and so on...

"Balance" is computed by subtracting "Total" from the previous
"Balance".

I'm not sure how to set "Balance" up in the subreport. Do I use a
running sum? If so, how?

Add a hidden text box (named txtRunExp) with control source
set to the total field and set its Running Sum property to
Over Group.

Then add a visible text box (named txtBalance) with a
control source expression like:
=Parent.txtBeginningBalance - txtRunExp

--
Marsh- Hide quoted text -

- Show quoted text -

Thank you so much. For some reason, I could not figure that out.