Form contains calculation but not updating tables

  • Thread starter Thread starter Trisha
  • Start date Start date
T

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
 
Trisha said:
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?
Click to expand...

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!
 
Back
Top