Calculated field in Access

Expand Post »

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

Similar Threads

How to create a Calculated and a Lookup Field in C#
Retrieve select info from field in MS Access db in Visual Basic 4 / 5 / 6
converting date from form to field in access in Visual Basic 4 / 5 / 6
Querying a Calculated Field? in MS Access and FileMaker Pro
Unique field/primary key for Access in Visual Basic 4 / 5 / 6

mars964

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2009

Permalink

Jul 7th, 2009

Re: Calculated field in Access

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

hiền muội

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jul 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS Access and FileMaker Pro Forum Timeline: SQL to Access question

Next Thread in MS Access and FileMaker Pro Forum Timeline: Multi-select listboxes

DaniWeb Message

Cancel Changes

User Name
Password