storing calculated values from forms into a database file

  • Thread starter Thread starter snimmuc
  • Start date Start date
S

snimmuc

I am new to Access. I have created a form with a calculated field. All other
data from the form stores OK back into the Database, BUT the calculated field
will not store in the database. The calculated field stores OK into the split
screen version of the form layout. Your help Please. I am using Access 2007
 
snimmuc said:
I am new to Access. I have created a form with a calculated field. All
other
data from the form stores OK back into the Database, BUT the calculated
field
will not store in the database. The calculated field stores OK into the
split
screen version of the form layout. Your help Please. I am using Access
2007
Click to expand...

Access saved you from making a mistake in database design. Unless you need
history, and are not storing the elements of the calculation, you should
never store the results of a calculation. Forms do not store data, they
allow entry and display.
 
Back
Top