storing calculated values from forms into a database file

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
 
A

Arvin Meyer [MVP]

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I get a calculated value from my form into a field in the 2
Data entry field calculated from manually entered field. 1
How to make a Calculated Field 4
Need help on how to pass calculated field from a form to another form 0
Access Deleted Table after Compact and Repair Database (Access 2010) 0
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Access Creating names from fields in access database. 0
Add new field in table that is the sum of fields in the same table 2

Top