Connecting Tech Pros Worldwide Forums | Help | Site Map

Access 2002: #Error Sum

Michael Dekson
Guest
 
Posts: n/a
#1: Nov 12 '05
In the report, when the result is 0 I would like to see 0 insted of #Error
Sum.
What must I do?
Thanks






Yamafopa!
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Access 2002: #Error Sum



Are you saying that you know the control should show 0 and it shows #Error
instead? If this is so, are you also saying that it WILL display answers
other than 0? I do not think this is likely. I think it more likely that the
expression evaluates to NULL or divides by 0 or something like that. Try
experimenting with IIF in the ControlSource of you control. Ensure that you
correctly reference any controls and trap for Nulls etc.

yamafopa!

"Michael Dekson" <nospam@nospam.com> wrote in message
news:bv5qvk$9kf$1@ariane.blic.net...[color=blue]
> In the report, when the result is 0 I would like to see 0 insted of #Error
> Sum.
> What must I do?
> Thanks
>
>
>
>
>[/color]


Closed Thread