Insert data into table by calculated files in form

[Trisha2014]

Dear,

I have calculated files in a form which is summimg the working hrs of each employées for a particular data.

I am able to show the same in the form but want to add this value in the table.

Is is possible to add this data from the form to the able????

 

[plog]

Just about anything is possible, but it is not advisable. Why do you believe you have to store this value? Why not create a query and just reference that query when you need the value?

Calculated values should not be stored, they should be calculated. That way when the underlying data changes, the calculation holds and you don't have to keep resaving data to a field in a table.