455,659 Members | 1,717 Online
Need help? Post your question and get tips & solutions from a community of 455,659 IT Pros & Developers. It's quick & easy.

Calculated field in Access

 P: 18 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. Nour Jun 14 '09 #1
5 Replies

 Expert Mod 5K+ P: 9,731 @Nour469 1 centimeter = 0.01 meters @Nour469 Have you considered formatting the field that represents the BMI such that it only has1 decimal place? Jun 16 '09 #2

 Expert 5K+ P: 8,685 @Nour469 As a Calculated Field in a Query: Expand|Select|Wrap|Line Numbers BM1: Format(([Weight])/(([Height]/100)^2),"#,#,#,#.0") Jun 16 '09 #3

 P: 18 @ADezii THANKS A MILLION..... THIS WORKED LIKE MAGIC! I just have a query on why could not I post this question on the "MsAccess" forum?? however, I am grateful for your reply... I truly appreciate it. Nour Jun 17 '09 #4

 Expert 5K+ P: 8,685 @Nour469 You are quite welcome, Nour469. Jun 17 '09 #5