Adding fields

[Arthur Cravan]

Forgive me for this question, I am sure there is an easy answer. I have a database with which I am tracking the number of days a person is in a campground by month. I have 12 fields, one per month. I have another field, Total Days in which I want to tally the numbers from the month. I can get the numbers to tally using an expression =[JAN]+[FEB]+[MAR]+[APR]+[MAY]+[JUN]+[JUL]+[AUG]+[SEP]+[OCT]+[NOV]+[DEC] but cannot get that value to store in the table. The only way I have been able to get the expression to work is by putting it into the ControSource field.

I know that this is a simple question, and that I am overlooking something obvious. Any help will be greatly appreciated.

Arthur

 

[DMC]

It is bad practice to store calculated values in a table (these are called notional fields). You would be better served calculating these values in a query or report so you can print off your results. Then use the form with the calculated field just for referring to a particular person