mlcktmguy
asked on
Total For Two Fields On a bound form
The user has requested a total of two fields on a form bound to a table (tblAccountInfo)
The fields are PrincipalAmt and InterestAmt.
T o create the total fields I copy and pasted the InterestAmt field.
I then replaced the control source with several variations of 'PrincipalAmt + InterestAmt' in one even included and = first '=PrincipalAmt + InterestAmt'
NO matter what I've tried I get the #Name in the field when the form is displayed.
What is the magic combination to get a total for these two fields on the screen?
The fields are PrincipalAmt and InterestAmt.
T o create the total fields I copy and pasted the InterestAmt field.
I then replaced the control source with several variations of 'PrincipalAmt + InterestAmt' in one even included and = first '=PrincipalAmt + InterestAmt'
NO matter what I've tried I get the #Name in the field when the form is displayed.
What is the magic combination to get a total for these two fields on the screen?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yep, that was the magic combo, enclosing each field in brackets
=Nz([PrincipalAmt],0) + Nz([InterestAmt],0)
This will avoid 'Null Propagation'
mx