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?
LVL 1
mlcktmguyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kevinreaCommented:
In the control source of your new field, that is, the one that you want the total to appear in , you want to put the following:
=[PrincipalAmt] + [InterestAmt]

Kevin Rea

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
You will also probably want to wrap each Field with Nz(), in case one of the values is Null and the other is not:

=Nz([PrincipalAmt],0) + Nz([InterestAmt],0)

This will avoid 'Null Propagation'

mx
mlcktmguyAuthor Commented:
Yep, that was the magic combo, enclosing each field in brackets
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.