Problem with RunningSum

Have have a running sum field in a report for job
categories, they total on each Call ID and then have a
Grand Total where the total of all of them come together
at the bottom to be included with the other rates based
on the total amount for the Date. My challenge is that
they all total fine for each date on Group All except
when one of the items in the job category field has a
0.00 value, then the running sum stops at the item above
it say 145.00, doesn't do anything with the zero value
one and then puts a 0.00 value in the Grand Total field
instead of the 145.00. As long as the fields are all
full it seems to work.

Can anyone help me with what would be correct to make
this work so that the amount that is supposed to be on
the bottom shows up.
Thanks, all help gratefully appreciated.
IEJ

I am not quite sure how your report is arranged, but if
you need the sum of a field in the (I assume) group
footer, why not us =Sum([YourField]) for the total.
Maybe you can clarify where each of the fields is located
and what you are trying to accomplish.
Hope this helps a little.
Fons
-----Original Message-----
Have have a running sum field in a report for job
categories, they total on each Call ID and then have a
Grand Total where the total of all of them come together
at the bottom to be included with the other rates based
on the total amount for the Date. My challenge is that
they all total fine for each date on Group All except
when one of the items in the job category field has a
0.00 value, then the running sum stops at the item above
it say 145.00, doesn't do anything with the zero value
one and then puts a 0.00 value in the Grand Total field
instead of the 145.00. As long as the fields are all
full it seems to work.

Can anyone help me with what would be correct to make
this work so that the amount that is supposed to be on
the bottom shows up.
Thanks, all help gratefully appreciated.
IEJ
.

Right off hand, it sounds as if the value of the field is Null, not zero,
but is being formatted to show zero. Null will propagate through an equation
and return Null, no matter how much other data is there. Try changing the
control source of this textbox to

=Nz([FieldName], 0)

This will change Null to zero so that there is a value that can be summed.
The FieldName will be whatever field you are currently using in that
textbox.

--
Wayne Morgan
Microsoft Access MVP


"IreneJ" wrote in message
...
Have have a running sum field in a report for job
categories, they total on each Call ID and then have a
Grand Total where the total of all of them come together
at the bottom to be included with the other rates based
on the total amount for the Date. My challenge is that
they all total fine for each date on Group All except
when one of the items in the job category field has a
0.00 value, then the running sum stops at the item above
it say 145.00, doesn't do anything with the zero value
one and then puts a 0.00 value in the Grand Total field
instead of the 145.00. As long as the fields are all
full it seems to work.

Can anyone help me with what would be correct to make
this work so that the amount that is supposed to be on
the bottom shows up.
Thanks, all help gratefully appreciated.
IEJ

Hi,
I am having the same problem as well.

But I tried using the Nz function that u proposed yet it still returned
error.What could the reason be?

The value in my text box is null, and I need to display it as 0 cos
I need to sum it as well.

Thanks very very much..


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Hi,
I am having the same problem as well.

But I tried using the Nz function that u proposed yet it still returned
error.What could the reason be?

The value in my text box is null, and I need to display it as 0 cos
I need to sum it as well.

Thanks very very much..


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

What error did you receive? If it didn't recognize the Nz command, then you
may have a problem with Library References. For information on fixing that,
read this.

http://members.iinet.net.au/~allenbrowne/ser-38.html

--
Wayne Morgan
Microsoft Access MVP


"tianseng" wrote in message
...

Hi,
I am having the same problem as well.

But I tried using the Nz function that u proposed yet it still returned
error.What could the reason be?

The value in my text box is null, and I need to display it as 0 cos
I need to sum it as well.

Thanks very very much..


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/