formulae

[andrew]

I have 2 fields in a table Total Hours + Total Hours2

A 3rd field is called Over Total - this should be adding Total Hours + Total
Hours2

Where best to write the formula and can you write me example because the
examples in helpfile are not working for me ... thank you...

Andrew..

 

[BruceM]

If you need to add the values from two fields, do it in a query or as the
Control Source of an unbound text box. In a query, at the top of a blank
column:
OverTotal: [Total Hours] + [Total Hours2]

As the Control Source of an unbound text box:
=[Total Hours] + [Total Hours2]

There is rarely a reason to store a calculated value. If you do so, be sure
you have code to update the calculation if any of the source fields ([Total
Hours] and [Total Hours2] in this case) changes in value.

I wonder about your design if you have a [Total Hours] field. As I
mentioned, totals are generally calculated on the fly. Again, you need to
make sure the total, if you are storing it, is recalculated if the source
fields change.