data calculated in a form doesn't update to the table

[Shrum]

I'm trying the sum a number of data fields within a
single record entered in a form. I built an expression
that works in the form to add the values together, but
the total doesn't update to my table, therefore does not
show up in quesries or reports based on that table.


Any ideas about how to accomplish this??

 

[Marshall Barton]

I'm trying the sum a number of data fields within a
single record entered in a form. I built an expression
that works in the form to add the values together, but
the total doesn't update to my table, therefore does not
show up in quesries or reports based on that table.

You don't want to do that. Normally, calculated values
should not be saved in a table, especially if the
calculation is based on other fields in the record.
Instead, the report's text box should use the same formula
to recalculate the total.

An exception to this rule is if the calculation include
values from another table that could be changed and cause
the recalculation to produce a different result (e.g. sales
tax).