Is there a way to calculate a value once and use it to update multiple fields?
Update Bio_data
set height = IIF(Left([age],3) < 20, 30,IIF([age],3) > 20, 60, 0))
weight = IIF(Left([age],3) < 20, 12,IIF([age],3) > 20, 50, 0))
The <computed value> is computed using a long formula using values in other fields. I'd like to not have to write out the long formula multiple times. In this example, I'd like to compute Left([age],3) once and reuse it at multiple places. This is just a representative calculation; it can be even longer.
I welcome alternative solutions, however I'd like to know if what I'm asking for is do-able.
Thank you.