#Error Sum Reply

  • Thread starter Thread starter Michael Dekson
  • Start date Start date
M

Michael Dekson

If result is 0 I see #Error Sum at the bottom of the page where I have my
calculation formula. But I want to see 0. If you want I can send you print
screen or if you want more information please contact me at
d e j a n dot m at b l i c dot net
 
=Sum([broj_poziva]) = addition all calls
=Sum([broj_impulsa]) = additions all telephone impulse

This is the formula that I use.
 
By zero, do you mean that there are no records in the report to be summed?
That would likely cause the #Error message you see. Try wrapping the field
with Nz function:

=Sum(Nz([broj_poziva],0))
=Sum(Nz([broj_impulsa],0))


--
Ken Snell
<MS ACCESS MVP>

Michael Dekson said:
=Sum([broj_poziva]) = addition all calls
=Sum([broj_impulsa]) = additions all telephone impulse

This is the formula that I use.


Michael Dekson said:
If result is 0 I see #Error Sum at the bottom of the page where I have my
calculation formula. But I want to see 0. If you want I can send you print
screen or if you want more information please contact me at
d e j a n dot m at b l i c dot net
Click to expand...
Click to expand...
 
Back
Top