On a form, subform2 I list $ amounts of bond deductions and in a field on that forms header area I sum up total amounts.
This field is a text box with the formula =IIf(Sum([amount])="",0,Sum([amount])) as the control source . This formulas sums the amounts below it.
Everything works fine until there are no records to be summed. When there is no records a 0 is displayed into the summed field and then it disappears leaving the summed field blank.
I want the 0 to remain in the field.
Any ideas on this problem would be greatly appreciated.