G
Guest
I have created a sum calculation in a subform that is then referenced in the
form. Is there a way to have the calculation return a 0 value if no records
are present in the subform?
I have changed all the default values to 0 in the properties and have tried
the formula =Sum(Nz([ActualAmount], 0)) without success.
If I enter a record in the subform with value 0 everthing works, but I don't
want to have to do that for every record.
Thanks in advance for your suggestions!
form. Is there a way to have the calculation return a 0 value if no records
are present in the subform?
I have changed all the default values to 0 in the properties and have tried
the formula =Sum(Nz([ActualAmount], 0)) without success.
If I enter a record in the subform with value 0 everthing works, but I don't
want to have to do that for every record.
Thanks in advance for your suggestions!