Summation in a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi , am a beginner to Access. Currently doing a Input form for my company.

In my database and input form , there's a HL Amt , EL Amt and a Total Ln Amt

Basically, when the user input the HL Amt and EL Amt at the form , I want
Access to show the Total Ln Amt (which is HL Amt + EL Amt) at the Form

Also this value shown in the Total Ln Amt would be reflected into the
database when the user saved the records

May i know how shld i go around doing it ?
 
-----Original Message-----
Basically, when the user input the HL Amt and EL Amt at the form , I want
Access to show the Total Ln Amt (which is HL Amt + EL
Click to expand...
Amt) at the Form

in the ControlSource of the total amount textbox put:

=[HL Amt] + [EL Amt]

where HL Amt and EL Amt are the names of your textboxes.
Also this value shown in the Total Ln Amt would be
reflected into the database when the user saved the
records
Click to expand...

You can delete the total field from your database's table
as it violates the purpose of database normalisation - a
search term definitely worth looking up, studying, and
understanding; especially if you want to get it right
first time.

As you have the two amounts stored in your table you can
calculate the total any time you want with a query thus
negating the need to ever store the total.
 
Back
Top