Repost-Can anyone help with runningsum

  • Thread starter Thread starter IreneJ
  • Start date Start date
I

IreneJ

Can anyone help me with this running sum problem, I am
desperate.

Totals come from items on a subreport, are formatted
currency, name of the field is CategoryTotal, control
source is =[JobCat].Report!Total (shown on left). Beside
it I have a running sum textbox called JobCatsRunningSum,
control source is =Val([CategoryTotal]). Then I have a
GrandTotal1 textbox below that that takes the total of
the running sum so that it can be put in a calculation,
control source is =[JobCatsRunningSum]
45.00 45.00
34.00 79.00
14.00 93.00
0.00 0.00

0.00 (GrandTotal1)
I want the running sum numbers to keep going to give me a
total but when it sees a 0.00 it won't pass the 0.00
field and just stops hence the the grand total textbox is
wrong. I tried to add the Nz to all the fields but nothing
seemed to change what its doing. Thank you so much for
your help.
Irene
 
I just tried this and I got the correct running sum as expected even though
the last value was null. I didn't use any Nz() anywhere in the report. I
think you have another issue. I would try create a new, blank report with
just the one text box set to running sum. Use the name of the running sum
text box in the control source of the text box in the report footer.
 
The source of the total is coming off a subreport and is
the total of two or three values there before it gets to
the running sum, do you think that might be something
that would cause a problem?
Thank you
 
Do each of the subreport instances have data?

--
Duane Hookom
MS Access MVP


IreneJ said:
The source of the total is coming off a subreport and is
the total of two or three values there before it gets to
the running sum, do you think that might be something
that would cause a problem?
Thank you
-----Original Message-----
Can anyone help me with this running sum problem, I am
desperate.

Totals come from items on a subreport, are formatted
currency, name of the field is CategoryTotal, control
source is =[JobCat].Report!Total (shown on left). Beside
it I have a running sum textbox called JobCatsRunningSum,
control source is =Val([CategoryTotal]). Then I have a
GrandTotal1 textbox below that that takes the total of
the running sum so that it can be put in a calculation,
control source is =[JobCatsRunningSum]
45.00 45.00
34.00 79.00
14.00 93.00
0.00 0.00

0.00 (GrandTotal1)
I want the running sum numbers to keep going to give me a
total but when it sees a 0.00 it won't pass the 0.00
field and just stops hence the the grand total textbox is
wrong. I tried to add the Nz to all the fields but nothing
seemed to change what its doing. Thank you so much for
your help.
Irene

.
Click to expand...
Click to expand...
 
Back
Top