Nulls to Zero's in Totaling a Subform
Posted on 2012-03-10
I have a subform that totals lost dollars on projects. There are many cases although where there are no lost dollars on a project. I'm trying to get the null value into a zero so when it is added to the main form I don't get the #Error. My current sum field in the subform footer to toal the field "Actual Cost" where the null occurs is:
If there is no records of dollars lost although I still get the sum field blank and not a zero, hence my main form creates the #Error on the main form.