Printing #Err# on sum function in report

  • Thread starter Thread starter Reji
  • Start date Start date
R

Reji

Sir,

I create a customer account statemnt report in Access.
There is no transaction for some customers in certain
period. So I am getiing #Err# in sum function. Instead of
#Err# I have to get 0 (zero) for these cases. How can I ?

Thnak you

Reji
 
Reji, I would suggest using the Nz function in the
calculation
=nz(Sum([YourValue]),0)
Hope this helps.
Fons
 
-----Original Message-----
Reji, I would suggest using the Nz function in the
calculation
=nz(Sum([YourValue]),0)
Hope this helps.
Fons
-----Original Message-----
Sir,

I create a customer account statemnt report in Access.
There is no transaction for some customers in certain
period. So I am getiing #Error# in sum function. Instead of
#Error# I have to get 0 (zero) for these cases. How can I ?

Thnak you

Reji
Click to expand...
Click to expand...

Fons,
Thank you very much for your immediate respons. I tried
with Nz method but not scuceed. Is there any other
solition for this ?

With Thanks
Reji
 
Reji. look at your calculations, you may have to apply
the Nz function to the various portions of your formula.
for instance:
=sum(Nz([firstvalue],0)*Nz([secondvalue],0))
try that, other wise give me the actual formula for review.
Fons
-----Original Message-----
-----Original Message-----
Reji, I would suggest using the Nz function in the
calculation
=nz(Sum([YourValue]),0)
Hope this helps.
Fons
-----Original Message-----
Sir,

I create a customer account statemnt report in Access.
There is no transaction for some customers in certain
period. So I am getiing #Error# in sum function.
Click to expand...
Click to expand...
Instead
of
Click to expand...

Fons,
Thank you very much for your immediate respons. I tried
with Nz method but not scuceed. Is there any other
solition for this ?

With Thanks
Reji
.
Click to expand...
 
Back
Top