View Full Version : Adding fields


Arthur Cravan
02-10-2000, 03:30 PM
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
02-11-2000, 12:08 AM
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