Use a calculated field to update multiple fields

[AnneForumer]

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.

[aytee111]

Create a function in a global module which does the calculation from the parameters that you pass it. You can then use it anywhere in the system.