Save a calulated expression to a table

[Ryker7]

I have a form the will calculate age based on system date and birthdate. The formula to do this is located in the query that the report is based upon. The formula consists of an IFF statement that not only calculates age but accounts for the fact that the birthday has not occured yet for the year. My question is how do I get access to save the calculated age to a table?

 

[glalsop]

Probably best to just store the Birth Date in the table, and perform the calculation whenever you need it. The age will be dynamic and constantly changing, which makes it a poor candidate to store as a field in your table.

-Gary