How do I add in a table

[trackmedic]

I have a table with the following fields

Total Hours
Total Hours worked
Total Hours Rest

I would like to automatically populate the Total Hours field by adding the other two field together. I can do it on a form with the following formula in an unbound field but it does not carry over to the table

=([Total Worked]+[Total Rest])

As always, thanks in advance

 

[namliam]

We do not store calculated values in tables, calculations are easily done in queries, forms, report when and where you need them.

We do not store calculated values in tables
We do not store calculated values in tables
We do not store calculated values in tables

Resistance is futile... We do not store calculated values in tables... you will obay !
Resistance is futile... We do not store calculated values in tables... you will obay !



All kidding asside though, you shouldnt store calculated values period.