From Form to Table

[whitestone]

Hello All,

I want to take a value from a field that only appears in a form and put it into a table. Do I do this using an update query? If so, how?

The file is called Age of Will in the form LegacyResearch. The value in the field comes from a function (=Year of Death - Year of Will), I want to move the values into a column of the same name in a table called LegacyInfo.

I hope someone can help.

Thanks

Ben

 

[Rich]

It's a calculated value and as such shouldn't be stored, just re-create the expression on a form/report or in a query