Formulas In Forms Error

[chrisguk]

Hi there,

Is anyone able to tell me whats wrong with the following. I have pasted the fields used in the process and the logic below. I have also written what they are for:

Field: [dteOriginalFrom] -
Behavior: Manual Date Entry

Field: [dteOriginalTo] -
Behavior: Manual Date Entry

Field: [OriginalAmount] -
Behavior: Manual Currency Entry

Field: [OriginalDays] -
Behavior:

=DateDiff("d",[dteOriginalFrom],[dteOriginalTo])

Field: [dteRebillFrom] -
Behavior: Manual Date Entry

Field: [dteRebillTo] -
Behavior: Manual Date Entry

Field: [RebillAmount] -
Behavior: Manual Currency Entry

Field: [RebillDays] -
Behavior:

=DateDiff("d",[dteRebillFrom],[dteRebillTo])

Field: [AmountDifference] -
Behavior:

=Nz([OriginalAmount]-[RebillAmount],0)

Field: [ImmediateSaving] -
Behavior:

=[amountdifference]

Field: [12MonthCostAvoidance] - THIS FIELD SHOWS THE "#Name?" ERROR NOT SURE WHY
Behavior:

=llf([amountdifference]=0,0,Nz([OriginalAmount],0)/[originaldays]*365)

Field: [CashReturn] -
Behavior: Manual Currency Entry

Field: [TotalSaving] - THIS FIELD SHOWS THE "#Num!" ERROR NOT SURE WHY
Behavior:

=(Nz([OriginalAmount]-[RebillAmount]))+Nz([OriginalAmount])/Nz([dteOriginalTo]-[dteOriginalFrom])*365+Nz([CashReturn])

Field: [sum1] -
Behavior:

=IIf([amountdifference]>0,1,0)

Field: [sum2] - THIS FIELD SHOWS THE "#Error" ERROR NOT SURE WHY
Behavior:

=IIf([12MonthCostAvoidance]>0,1,0)

Field: [sum3] -
Behavior:

=IIf(Nz([CashReturn],0)>0,1,0)

Field: [sumResult] -
Behavior:

=IIf([Sum1]+[Sum2]+[sum3]=3,"Sorry this is not a valid claim","Valid Claim")

Hopefully you can see the logic in the formulas but if you need further explanation I can do that.

Thank you in advance