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

=Sum #Error

P: n/a
I have 2 reports with =Sum([Amt Paid]) in the report footer.
This same, identical report exists in 2 identical databases, on the same
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?

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.