My calculated field output is not displayed in my table.

[xtrareal22]

I am doing a project on database stock management system.first time using access and i have been playing around with it. I have created three tables and forms for each table.On the form design i have created a calculated field as the control source for one of the field that is also present in the table.The results or output is shown on the form field but not in the table field.I don't what to do. pls help!!!

[Missinglinq]

This is good! It is very seldom that it is appropriate for Calculated Fields to be stored in Tables; instead, you simply re-calculate them, as needed.

Allen Browne explains the whys and wherefores of not storing them, and outlines the how to, if you simply must:

http://allenbrowne.com/casu-14.html

Linq ;0)>

[Dal Jeanis]

1) If the field is calculated from other data in the same record, then what missinglinq said is correct, you shouldn't store it.

2) If the field is calculated based on other things the user is entering, then you can do this -
(A) Add a textbox linked to the field in the database. Set Visible to No for this textbox.
(B) In the afterupdate event of the calculated field, set the value of the textbox field.

Obviously, you'd generally only want to do that at data entry time.