Solved

Total For Two Fields On a bound form

Posted on 2014-01-02
3
284 Views
Last Modified: 2014-01-02
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?
0
Comment
Question by:mlcktmguy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 

Accepted Solution

by:
kevinrea earned 250 total points
ID: 39753087
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
0
 
LVL 75
ID: 39753094
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
0
 
LVL 1

Author Closing Comment

by:mlcktmguy
ID: 39753095
Yep, that was the magic combo, enclosing each field in brackets
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question