merge two field value in one field in access

[sharad.sony]

I have a table in access which contains 3 columns named A, B & C.

I want that when i put the value in column A & B the value of column C automatically merge and shows as A + B in table.

How can i do this.


Sharad.

 

[nyaworld]

See Attached Sample DB ... ... ..

I need help with something more challenging....

A=weight
B=height

A is number, B is number and I need the following output in a calculated field, C:

Weight is: 200 lbs. Height is: 60 inches BMI is : 20.5 39.1

I want the above statement to be in one field.... field C

The BMI is calculated like this ([Weight (lbs)],10),1,4)+(703*([Weight (lbs)])/([Height (in)]*[Height (in)

Those fields are A and B.

 

[nyaworld]

That formula doesn't look right?

http://www.whathealth.com/bmi/formula.html

The formula I am using is correct, I just didn't run the weight and height via my formula when I was giving an example.

The BMI result from formula for 200lbs and 60" is 39.1

I eventually figured out the correct expression in my calculated field:

IIf([Height (in)]=0,"Missing Height","Height: "+SubString(Right([Height (in)],5),1,5)+" in. Weight: "+SubString(Right([Weight (lbs)],5),1,5)+" lbs. BMI: "+SubString(Right(((703*([Weight (lbs)])/([Height (in)]*[Height (in)]))),10),1,4))

Thanks for your responses !

 

[nyaworld]

Please ..... your original formula as posted was NOT correct.

It didn't have "IIF" in it...
It didn't have "Missing" in it...
It didn't have "Substring" in it...

Sent from my SM-G925F using Tapatalk

The original formula works for one calculated field. I then added the IIF statement because you can't divide by zero and what I posted afterwards was the final formula I finally figured out to combine 3 different fields including the original formula for BMI and has a result of "Missing height" when the medical assistant skips adding the value for height.

Thank you for your efforts.

 

[sharad.sony]

I think uncle is right

 

[arnelgp]

what is the correct formula without coding:

Bmi = 703 x height / weight * weight (am i correct?)

 

[sharad.sony]

Correct. BMI formula is