Bind function to table

[whitestone]

Another possibly simple question from me........

I have created a couple of fields on a form in my fundraising legacy database that have functions that work out specific dates. For example, one takes the date of death minus the date the will was made to work out the age of the will. The date of death and date of will are bound to fields in a table and I wanted the age of will to be bound to a field of the same name which is in the table. How do I do this? I thought I may have to do an update query that links to the field on the form but not sure.

Thanks for everyones help so far and I hope you can help with this too.

Ben

 

[boblarson]

It's best to not store calculated fields. Since you have the dates in the table, you can recreate the age calculation at any time. This is a normalization rule. But, if you still don't want to follow the standard rules of normalization, an update query will do what you requested.