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

=Sum #Error

P: n/a
Hi,
I have 2 reports with =Sum([Amt Paid]) in the report footer.
This same, identical report exists in 2 identical databases, on the same
machine.
One report shows $0.00 if there are no entries in the Amt Paid field.
The other report shows #Error if there is no entry in the Amt Paid field.
Once I enter a value into the Amt Paid field of the erroneous report,
(via a form), it sums the values fine.
I wonder why they act differently?

Thanks,
Mark
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.