Member Avatar for mars964

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

  • 2 Contributors
  • 1 Reply
  • 78 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by hiền muội
Member Avatar for hiền muội

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.