Calculated field in Access
 

Hello,

This was supposed to be easy but I could not get it!
I need to create a calculated field in Access (preferably in a table or maybe a query) that calculates the BMI. I have fields for the weight in kgs and Height in cm. The formula is:
BMI=(Wt(in kg)/(Ht (in meters)^2)). However, as the height is stored in cm I need to convert it to meter. And also, I need the BMI with only 1 decimal place (for example: 23.6)
I came up with the expression:
=([Tbl1]![weight])/(([Tbl1]![Height]/100)^2)

Can anyone help!
Thank You.
Mona

Re: Calculated field in Access
 

Try code:
=FormatNumber(([Tbl1]![weight])/(([Tbl1]![Height]/100)^2) ,1)