Adding several fields to arrive at a sum

  • Thread starter Thread starter Chris Christian Read
  • Start date Start date
C

Chris Christian Read

Does anyone know how to add several fields together in a
form to arrive at a grand total? I am a social worker who
uses an access database and need to have the clients
living expenses add up automatically. If anyone can HELP
Thank you!!
 
add an unbound field to your form in that field put a formula similar to...

= [SomeFieldName1] + [SomeFieldName2] + [SomeFieldName3) + [Some...

Enter your field names and include as many fields as needed.

Hope that helps.

Rick B




message Does anyone know how to add several fields together in a
form to arrive at a grand total? I am a social worker who
uses an access database and need to have the clients
living expenses add up automatically. If anyone can HELP
Thank you!!
 
Chris said:
Does anyone know how to add several fields together in a
form to arrive at a grand total? I am a social worker who
uses an access database and need to have the clients
living expenses add up automatically. If anyone can HELP
Thank you!!
Click to expand...

Living expenses should be in a separate table and appear in a subform.
You would use Sum([YourExpenseField]) to get the total and refer to it on
the main form.

The Northwind database has examples of this.
 
Back
Top