BMI calculation formula not working...

[coolpal9]

Hi,



In my form I had two textboxes: one for Height and the other for Weight. And then another textbox BMI, whose value I got it calculated from the formula =Format(([Weight])/(([Height]/100)^2),"0.0")

But my worry is that it is not working. Pl someone help me, its very urgent and I have to make it work.

[RuralGuy]

Are the Height and Weight controls bound to fields in a query? If so then your BMI control formula should be in the query.

[TheShabz]

This comment is more for the BMI calculations than Access. The height/weight formulas are very archaic and really shouldn't be used anymore. Calculating one's true BMI is a simple process nowadays. If you think about it, going off of a height/weight chart, every athlete is overweight/obese. Two people 6'0" 220lbs would both be considered obese. One of those is a couch potato and the other is a football player. Two COMPLETELY different body compositions.