I am trying to calculated a field (called success) based off a few things ..
one being a yes/no checkbox where the value is stored as a 0 or -1 in the table, and a few other fields (user input in the form.)
currently i am trying to calculate this as a 'before update' on the field success. i am unsure if i should have it calculated there or calculated as the 'control source' because i do want this value to be saved in my underlying table.
all of the data of the form comes from one table.
here is the code that i am currently using
Me.success = (Me.height) * (Me.age) * (Me.weight) ^ (0.5 * Abs(Me.sex)) / 24 * Me.race
when i run this, i get an "#ERROR" in the field i am trying to calculate. ..
what i'm trying to do is make
success = (height*age*weight(^.5*abs(sex))) /24 * race
height x age x weight to the 1/2 power * the absolute value of sex divided by 24 times race
any ideas on how to make this formula work? i'm dealing with powers absolute values ... i think that's where my error is.
thank you *so* much in advance and i'll provide more info if you need it.
one being a yes/no checkbox where the value is stored as a 0 or -1 in the table, and a few other fields (user input in the form.)
currently i am trying to calculate this as a 'before update' on the field success. i am unsure if i should have it calculated there or calculated as the 'control source' because i do want this value to be saved in my underlying table.
all of the data of the form comes from one table.
here is the code that i am currently using
Me.success = (Me.height) * (Me.age) * (Me.weight) ^ (0.5 * Abs(Me.sex)) / 24 * Me.race
when i run this, i get an "#ERROR" in the field i am trying to calculate. ..
what i'm trying to do is make
success = (height*age*weight(^.5*abs(sex))) /24 * race
height x age x weight to the 1/2 power * the absolute value of sex divided by 24 times race
any ideas on how to make this formula work? i'm dealing with powers absolute values ... i think that's where my error is.
thank you *so* much in advance and i'll provide more info if you need it.