I
IreneJ
Thank you, may I ask for some clarification as I'm not
clear on how to implement the Nz item you posted. I have
added some further clarifying text that may make my
question clearer I hope.
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 number of 93.00 to pass the 0.00
field so that it will populate the grand total textbox.
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
clear on how to implement the Nz item you posted. I have
added some further clarifying text that may make my
question clearer I hope.
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 number of 93.00 to pass the 0.00
field so that it will populate the grand total textbox.
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