Getting #Error on sum function in report

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

Reji

Sir,

I designed a customer account satement report. In this
report for some customers there is no data for calcualtion
in certain period. So I am getting #Error as the value in
sum([value) fuction . I tried with Nz function to avoid
this problem, but not succeed. Is there any remedy for
this?

Thank you very much

Reji Eapen
 
Is what you posted what you actually have in the control source:
sum([value)

If yes, change it to this:
sum([value])

Also, note that it's not a good idea to use Value (and many other words) as
the name of fields or controls. These are reserved words in ACCESS, and have
special meanings to ACCESS. You can greatly confuse ACCESS if you use them
incorrectly. See KB article number 286335 for more info:

ACC2002: Reserved Words in Microsoft Access
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
 
Back
Top