By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,659 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
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
Share this Question
Share on Google+
5 Replies


Frinavale
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

ADezii
Expert 5K+
P: 8,685
@Nour469
As a Calculated Field in a Query:
Expand|Select|Wrap|Line Numbers
  1. 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

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

Frinavale
Expert Mod 5K+
P: 9,731
@Nour469
When you select MS Access from the menu it will bring you to a "Topics" page. That page has 2 links on it: "Insights" and "Answers". If you follow the Insights link you'll find a number of articles that are Access related. If you follow the link to the Answers forum you'll find answers to Access questions (this where you are able to post your question). You cannot post your question in the Topics page and should not in the Insights (unless it's an article)...so in the future ask your Access questions in the Access->Answers forum.

:)

-Frinny
Jun 17 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.