how do i make a totals fieldthat adds automatically

[Guest]

I am working on a database that contains student information and have several
different columns which includes different types of fees. I need to be able
to add a total colunm to my database but don't know how to make it calculate.
For example if a student owes a book fine of $5 and a misc. fine of $10 I
need the total column to automatically sum $15. How should I go about doing
this? Thanks in advance for any replies.

 

[G. Vaught]

The total field will be a calculated field and not stored in your database.
If you want to add this to a form or report you can total the field by
adding a textbox control in the design part of your form or report. Open the
textbox properties and in the control source part of the field type the
following: =[field1name] + [field2name]. You can set the Format of this
field to Currency to show the $ sign.

You can also do this in a query, if your form or report is based on a query.
To do this, you type in a blank column on the top row:
GrandTotal:[field1name] + [field2name]. This creates a new field by the name
as GrandTotal on the fly. To show this in currency, you must right click on
the new field name and open properties.