By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,139 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,139 IT Pros & Developers. It's quick & easy.

Access 2002: #Error Sum

P: n/a
In the report, when the result is 0 I would like to see 0 insted of #Error
Sum.
What must I do?
Thanks

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

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" <no****@nospam.com> wrote in message
news:bv**********@ariane.blic.net...
In the report, when the result is 0 I would like to see 0 insted of #Error
Sum.
What must I do?
Thanks


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.