calculation

[Guest]

Hi,
In Excel, I use the formula below to calculate if the patient is obese or
not.

=IF(703*(B1/(A1*A1))>30,"Y","N"). It works very well.
--------------------------------------
I would like to make it works in Access as well.

I have three text boxes-- height, weight and obesity-- in the form. As soon
as I enter info in the height and weight boxes, I wish the obesity text box
will show Y or N.

Is there a way to do that?
Please help
Chi Huynh


Is there a way to do that?
Please help
Chi Huynh

 

[Guest]

In the obesity text box you can use IIF

=IIF(703*([B1]/([A1]*[A1]))>30,"Y","N")

Note: change B1 and A1 to the fields names

 

[Guest]

In the obesity text box ControlSource you can use IIF

=IIF(703*([B1]/([A1]*[A1]))>30,"Y","N")

Note: change B1 and A1 to the fields names

 

[Guest]

Hi Ofer Cohen,

I am really appreciated for all your help! The formula works perfectly!!
Do you mind to tell me what your real name is? Is Ofer your first name?
Thanks
Chi Huynh

In the obesity text box you can use IIF

=IIF(703*([B1]/([A1]*[A1]))>30,"Y","N")

Note: change B1 and A1 to the fields names

--
Good Luck
BS"D

Hi,
In Excel, I use the formula below to calculate if the patient is obese or
not.

=IF(703*(B1/(A1*A1))>30,"Y","N"). It works very well.
--------------------------------------
I would like to make it works in Access as well.

I have three text boxes-- height, weight and obesity-- in the form. As soon
as I enter info in the height and weight boxes, I wish the obesity text box
will show Y or N.

Is there a way to do that?
Please help
Chi Huynh


Is there a way to do that?
Please help
Chi Huynh

 

[Guest]

Yes, my first name is Ofer (It's in Hebrew - which mean a Fawn)

--
Good Luck
BS"D

Hi Ofer Cohen,

I am really appreciated for all your help! The formula works perfectly!!
Do you mind to tell me what your real name is? Is Ofer your first name?
Thanks
Chi Huynh

In the obesity text box you can use IIF

=IIF(703*([B1]/([A1]*[A1]))>30,"Y","N")

Note: change B1 and A1 to the fields names

--
Good Luck
BS"D

Hi,
In Excel, I use the formula below to calculate if the patient is obese or
not.

=IF(703*(B1/(A1*A1))>30,"Y","N"). It works very well.
--------------------------------------
I would like to make it works in Access as well.

I have three text boxes-- height, weight and obesity-- in the form. As soon
as I enter info in the height and weight boxes, I wish the obesity text box
will show Y or N.

Is there a way to do that?
Please help
Chi Huynh


Is there a way to do that?
Please help
Chi Huynh

 

[Guest]

Thank you!!
Chi Huynh

Yes, my first name is Ofer (It's in Hebrew - which mean a Fawn)

--
Good Luck
BS"D

Hi Ofer Cohen,

I am really appreciated for all your help! The formula works perfectly!!
Do you mind to tell me what your real name is? Is Ofer your first name?
Thanks
Chi Huynh

In the obesity text box you can use IIF

=IIF(703*([B1]/([A1]*[A1]))>30,"Y","N")

Note: change B1 and A1 to the fields names

--
Good Luck
BS"D


:

Hi,
In Excel, I use the formula below to calculate if the patient is obese or
not.

=IF(703*(B1/(A1*A1))>30,"Y","N"). It works very well.
--------------------------------------
I would like to make it works in Access as well.

I have three text boxes-- height, weight and obesity-- in the form. As soon
as I enter info in the height and weight boxes, I wish the obesity text box
will show Y or N.

Is there a way to do that?
Please help
Chi Huynh


Is there a way to do that?
Please help
Chi Huynh