Form contains calculation but not updating tables

[Trisha]

I have a form that adds several columns together and
diplays them in the form. I want to update a column in my
table with that total number without calculating it myself
and entering it. Is there some way for me to do this?

Thanks,
Trisha

 

[Rick Brandt]

I have a form that adds several columns together and
diplays them in the form. I want to update a column in my
table with that total number without calculating it myself
and entering it. Is there some way for me to do this?

It's considered poor design practice to store values than can be derived
from other fields. Just put your calculation into a query along with the
other fields from your table and then use the query every place you would
ordinarily use the table. You're using a computer so let it compute!