In the report, when the result is 0 I would like to see 0 insted of #Error
Sum.
What must I do?
Thanks
Sum.
What must I do?
Thanks
-
-
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]
Comment