ADDING FIELDS IN REPORT THAT INCLUDES SUBREPORTS

[rstitzel]

I have a report that is an AR Statement. On the form I have the following fields Total Invoices, Total Payments (subreport), Total Adjustments (subreport), Interest (subreport) and Ending Balance (subreport). I then have a field called Beginning Balance where I'm taking Ending Balance + Total Payments - Total Invoices - Total Interest. Excluding the Ending Balance field, the other fields may or may not have a value. If one of the fields doesn't have a value an #error is generated. What can I do to make sure my Beginning Balance field always calculates regardless if some of the fields have no value.

Any and all help is appreciated.

 

[scriverb]

Try using the NZ function which analyzes the result and if Null it returns a zero(0).
Example:=NZ([Total Invoice]),0)

Now when you rollup these controls there will be at least a zero(0) value in the control. Bob Scriver