On the 'SumPayments' field I have tried the following:
=Sum(IIf([Total]=NULL,0))
=Sum(IIf([Total]="",0))
=Sum(IIf([Total]=' ',0))
The field remains blank until a payment line is added or 'Deposit' tick box is checked.. The calculated fields then populate.
Thanks
Phil.