Body Surface area code

[RobUCSD]

I need have a calculated field based on hight and wt in inches and pounds.
Can anyone help implement this?

Thanks and Happy Hollidays!

RobUCSD

BSA (m²) = ( [Height(in) x Weight(lbs) ]/ 3131 )½

 

[John Nurick]

BSA (m²) = ( [Height(in) x Weight(lbs) ]/ 3131 )½

Sqr(([Height] * [Weight])/3131)

 

[RobUCSD]

Thankyou John for your help. I tried inserting
=Sqr(([fldHeightInches]*[fldWeightPounds])/3131) in the default value
property of fldBSA. I get an error msg that says that the database does not
recognize the field fldHeightInches or the table tblClinicalPresentation.
any suggestions?

FYI I know you're not supposed to store the value of a calculated field in a
field, but I need the field with the BSA for statistical purposes.

Thanks, RobUCSD

BSA (m²) = ( [Height(in) x Weight(lbs) ]/ 3131 )½

Sqr(([Height] * [Weight])/3131)

 

[Douglas J. Steele]

Create a query that has that calculation in it. Use the query wherever you
would otherwise have used the table.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thankyou John for your help. I tried inserting
=Sqr(([fldHeightInches]*[fldWeightPounds])/3131) in the default value
property of fldBSA. I get an error msg that says that the database does
not
recognize the field fldHeightInches or the table tblClinicalPresentation.
any suggestions?

FYI I know you're not supposed to store the value of a calculated field in
a
field, but I need the field with the BSA for statistical purposes.

Thanks, RobUCSD

BSA (m²) = ( [Height(in) x Weight(lbs) ]/ 3131 )½

Sqr(([Height] * [Weight])/3131)

 

[RobUCSD]

Hello Again Doug. I tried insterting the calculation into the query but have
had no luck. Is there some kind of lead in to call a calculation for a field
in sql?

Your help is greatly appreciated,

Rob

Create a query that has that calculation in it. Use the query wherever you
would otherwise have used the table.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thankyou John for your help. I tried inserting
=Sqr(([fldHeightInches]*[fldWeightPounds])/3131) in the default value
property of fldBSA. I get an error msg that says that the database does
not
recognize the field fldHeightInches or the table tblClinicalPresentation.
any suggestions?

FYI I know you're not supposed to store the value of a calculated field in
a
field, but I need the field with the BSA for statistical purposes.

Thanks, RobUCSD

On Fri, 22 Dec 2006 19:47:00 -0800, RobUCSD


BSA (m²) = ( [Height(in) x Weight(lbs) ]/ 3131 )½

Sqr(([Height] * [Weight])/3131)

 

[Douglas J. Steele]

How did you insert the calculation?

It should be as simple as putting

BSA: Sqr(([Height] * [Weight])/3131)

into an empty cell on the Field row of the grid (assuming you have fields
named Height and Weight in your table).

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hello Again Doug. I tried insterting the calculation into the query but
have
had no luck. Is there some kind of lead in to call a calculation for a
field
in sql?

Your help is greatly appreciated,

Rob

Create a query that has that calculation in it. Use the query wherever
you
would otherwise have used the table.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thankyou John for your help. I tried inserting
=Sqr(([fldHeightInches]*[fldWeightPounds])/3131) in the default value
property of fldBSA. I get an error msg that says that the database does
not
recognize the field fldHeightInches or the table
tblClinicalPresentation.
any suggestions?

FYI I know you're not supposed to store the value of a calculated field
in
a
field, but I need the field with the BSA for statistical purposes.

Thanks, RobUCSD

:

On Fri, 22 Dec 2006 19:47:00 -0800, RobUCSD


BSA (m²) = ( [Height(in) x Weight(lbs) ]/ 3131 )½

Sqr(([Height] * [Weight])/3131)

 

[RobUCSD]

It just doesn't work in the query. I get the error msg that the expression is
too complex.

Is there a way I could do this thru code on the form?

Thanks for your help

How did you insert the calculation?

It should be as simple as putting

BSA: Sqr(([Height] * [Weight])/3131)

into an empty cell on the Field row of the grid (assuming you have fields
named Height and Weight in your table).

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hello Again Doug. I tried insterting the calculation into the query but
have
had no luck. Is there some kind of lead in to call a calculation for a
field
in sql?

Your help is greatly appreciated,

Rob

Create a query that has that calculation in it. Use the query wherever
you
would otherwise have used the table.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Thankyou John for your help. I tried inserting
=Sqr(([fldHeightInches]*[fldWeightPounds])/3131) in the default value
property of fldBSA. I get an error msg that says that the database does
not
recognize the field fldHeightInches or the table
tblClinicalPresentation.
any suggestions?

FYI I know you're not supposed to store the value of a calculated field
in
a
field, but I need the field with the BSA for statistical purposes.

Thanks, RobUCSD

:

On Fri, 22 Dec 2006 19:47:00 -0800, RobUCSD


BSA (m²) = ( [Height(in) x Weight(lbs) ]/ 3131 )½

Sqr(([Height] * [Weight])/3131)

 

[John Nurick]

Can you show us the SQL of the query?

It just doesn't work in the query. I get the error msg that the expression is
too complex.

Is there a way I could do this thru code on the form?

Thanks for your help

How did you insert the calculation?

It should be as simple as putting

BSA: Sqr(([Height] * [Weight])/3131)

into an empty cell on the Field row of the grid (assuming you have fields
named Height and Weight in your table).

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hello Again Doug. I tried insterting the calculation into the query but
have
had no luck. Is there some kind of lead in to call a calculation for a
field
in sql?

Your help is greatly appreciated,

Rob

:

Create a query that has that calculation in it. Use the query wherever
you
would otherwise have used the table.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Thankyou John for your help. I tried inserting
=Sqr(([fldHeightInches]*[fldWeightPounds])/3131) in the default value
property of fldBSA. I get an error msg that says that the database does
not
recognize the field fldHeightInches or the table
tblClinicalPresentation.
any suggestions?

FYI I know you're not supposed to store the value of a calculated field
in
a
field, but I need the field with the BSA for statistical purposes.

Thanks, RobUCSD

:

On Fri, 22 Dec 2006 19:47:00 -0800, RobUCSD


BSA (m²) = ( [Height(in) x Weight(lbs) ]/ 3131 )½

Sqr(([Height] * [Weight])/3131)

 

[RobUCSD]

here's the query as requested. thanks for your help with this


SELECT tblClinicalPresentation.fldCPNo, tblClinicalPresentation.fldVisitNo,
tblClinicalPresentation.fldHeightInches,
tblClinicalPresentation.fldWeightPounds, tblClinicalPresentation.fldBSA,
tblClinicalPresentation.fldRhythm, tblClinicalPresentation.fldAFibType,
tblClinicalPresentation.[fldEpisodes>72hrs],
tblClinicalPresentation.fldNoWeeksOfAfib,
tblClinicalPresentation.fldNoYearsOfAfib,
tblClinicalPresentation.fldSeverityOfPalpitation,
tblClinicalPresentation.fldSeverityOfFatigue,
tblClinicalPresentation.fldSeverityOfSOB,
tblClinicalPresentation.fldSeverityOfDizziness,
tblClinicalPresentation.fldSeverityOfLackOfEnergy,
tblClinicalPresentation.fldHistoryOfCardioversion,
tblClinicalPresentation.fldAfibFrequency
FROM tblClinicalPresentation
WHERE
(((tblClinicalPresentation.fldBSA)=Sqr(([fldHeightInches]*[fldWeightPounds])/3131)));

Can you show us the SQL of the query?

It just doesn't work in the query. I get the error msg that the expression is
too complex.

Is there a way I could do this thru code on the form?

Thanks for your help

How did you insert the calculation?

It should be as simple as putting

BSA: Sqr(([Height] * [Weight])/3131)

into an empty cell on the Field row of the grid (assuming you have fields
named Height and Weight in your table).

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Hello Again Doug. I tried insterting the calculation into the query but
have
had no luck. Is there some kind of lead in to call a calculation for a
field
in sql?

Your help is greatly appreciated,

Rob

:

Create a query that has that calculation in it. Use the query wherever
you
would otherwise have used the table.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Thankyou John for your help. I tried inserting
=Sqr(([fldHeightInches]*[fldWeightPounds])/3131) in the default value
property of fldBSA. I get an error msg that says that the database does
not
recognize the field fldHeightInches or the table
tblClinicalPresentation.
any suggestions?

FYI I know you're not supposed to store the value of a calculated field
in
a
field, but I need the field with the BSA for statistical purposes.

Thanks, RobUCSD

:

On Fri, 22 Dec 2006 19:47:00 -0800, RobUCSD


BSA (m²) = ( [Height(in) x Weight(lbs) ]/ 3131 )½

Sqr(([Height] * [Weight])/3131)

 

[John Nurick]

Hi Rob,

The SQL you posted will return all records from tblClinicalPresentation
where the the value of the field [fldBSA] is equal to the surface area
calculated from [fldHeightInches] and [fldWeightPounds]. As I understand
it, you don't have a BSA field, so that is presumably the problem. To
calculate BSA, the query should be like this:

SELECT tblClinicalPresentation.fldCPNo,
tblClinicalPresentation.fldVisitNo,
tblClinicalPresentation.fldHeightInches,
tblClinicalPresentation.fldWeightPounds,
Sqr([fldHeightInches]*[fldWeightPounds]/3131) AS BSA,
...
FROM tblClinicalPresentation
;

here's the query as requested. thanks for your help with this


SELECT tblClinicalPresentation.fldCPNo, tblClinicalPresentation.fldVisitNo,
tblClinicalPresentation.fldHeightInches,
tblClinicalPresentation.fldWeightPounds, tblClinicalPresentation.fldBSA,
tblClinicalPresentation.fldRhythm, tblClinicalPresentation.fldAFibType,
tblClinicalPresentation.[fldEpisodes>72hrs],
tblClinicalPresentation.fldNoWeeksOfAfib,
tblClinicalPresentation.fldNoYearsOfAfib,
tblClinicalPresentation.fldSeverityOfPalpitation,
tblClinicalPresentation.fldSeverityOfFatigue,
tblClinicalPresentation.fldSeverityOfSOB,
tblClinicalPresentation.fldSeverityOfDizziness,
tblClinicalPresentation.fldSeverityOfLackOfEnergy,
tblClinicalPresentation.fldHistoryOfCardioversion,
tblClinicalPresentation.fldAfibFrequency
FROM tblClinicalPresentation
WHERE
(((tblClinicalPresentation.fldBSA)=Sqr(([fldHeightInches]*[fldWeightPounds])/3131)));

Can you show us the SQL of the query?

It just doesn't work in the query. I get the error msg that the expression is
too complex.

Is there a way I could do this thru code on the form?

Thanks for your help

:

How did you insert the calculation?

It should be as simple as putting

BSA: Sqr(([Height] * [Weight])/3131)

into an empty cell on the Field row of the grid (assuming you have fields
named Height and Weight in your table).

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Hello Again Doug. I tried insterting the calculation into the query but
have
had no luck. Is there some kind of lead in to call a calculation for a
field
in sql?

Your help is greatly appreciated,

Rob

:

Create a query that has that calculation in it. Use the query wherever
you
would otherwise have used the table.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Thankyou John for your help. I tried inserting
=Sqr(([fldHeightInches]*[fldWeightPounds])/3131) in the default value
property of fldBSA. I get an error msg that says that the database does
not
recognize the field fldHeightInches or the table
tblClinicalPresentation.
any suggestions?

FYI I know you're not supposed to store the value of a calculated field
in
a
field, but I need the field with the BSA for statistical purposes.

Thanks, RobUCSD

:

On Fri, 22 Dec 2006 19:47:00 -0800, RobUCSD


BSA (m²) = ( [Height(in) x Weight(lbs) ]/ 3131 )½

Sqr(([Height] * [Weight])/3131)

 

[RobUCSD]

Dear MS Access MVP's, thankyou all for what you do. Thankyou John for your
help, the solution you gave works perfectly. Merry Christmas to everyone and
may 2007 be a very prosperous and peaceful year for you and your families.

Rob

Hi Rob,

The SQL you posted will return all records from tblClinicalPresentation
where the the value of the field [fldBSA] is equal to the surface area
calculated from [fldHeightInches] and [fldWeightPounds]. As I understand
it, you don't have a BSA field, so that is presumably the problem. To
calculate BSA, the query should be like this:

SELECT tblClinicalPresentation.fldCPNo,
tblClinicalPresentation.fldVisitNo,
tblClinicalPresentation.fldHeightInches,
tblClinicalPresentation.fldWeightPounds,
Sqr([fldHeightInches]*[fldWeightPounds]/3131) AS BSA,
...
FROM tblClinicalPresentation
;

here's the query as requested. thanks for your help with this


SELECT tblClinicalPresentation.fldCPNo, tblClinicalPresentation.fldVisitNo,
tblClinicalPresentation.fldHeightInches,
tblClinicalPresentation.fldWeightPounds, tblClinicalPresentation.fldBSA,
tblClinicalPresentation.fldRhythm, tblClinicalPresentation.fldAFibType,
tblClinicalPresentation.[fldEpisodes>72hrs],
tblClinicalPresentation.fldNoWeeksOfAfib,
tblClinicalPresentation.fldNoYearsOfAfib,
tblClinicalPresentation.fldSeverityOfPalpitation,
tblClinicalPresentation.fldSeverityOfFatigue,
tblClinicalPresentation.fldSeverityOfSOB,
tblClinicalPresentation.fldSeverityOfDizziness,
tblClinicalPresentation.fldSeverityOfLackOfEnergy,
tblClinicalPresentation.fldHistoryOfCardioversion,
tblClinicalPresentation.fldAfibFrequency
FROM tblClinicalPresentation
WHERE
(((tblClinicalPresentation.fldBSA)=Sqr(([fldHeightInches]*[fldWeightPounds])/3131)));

Can you show us the SQL of the query?

On Sat, 23 Dec 2006 20:19:00 -0800, RobUCSD

It just doesn't work in the query. I get the error msg that the expression is
too complex.

Is there a way I could do this thru code on the form?

Thanks for your help

:

How did you insert the calculation?

It should be as simple as putting

BSA: Sqr(([Height] * [Weight])/3131)

into an empty cell on the Field row of the grid (assuming you have fields
named Height and Weight in your table).

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Hello Again Doug. I tried insterting the calculation into the query but
have
had no luck. Is there some kind of lead in to call a calculation for a
field
in sql?

Your help is greatly appreciated,

Rob

:

Create a query that has that calculation in it. Use the query wherever
you
would otherwise have used the table.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Thankyou John for your help. I tried inserting
=Sqr(([fldHeightInches]*[fldWeightPounds])/3131) in the default value
property of fldBSA. I get an error msg that says that the database does
not
recognize the field fldHeightInches or the table
tblClinicalPresentation.
any suggestions?

FYI I know you're not supposed to store the value of a calculated field
in
a
field, but I need the field with the BSA for statistical purposes.

Thanks, RobUCSD

:

On Fri, 22 Dec 2006 19:47:00 -0800, RobUCSD


BSA (m²) = ( [Height(in) x Weight(lbs) ]/ 3131 )½

Sqr(([Height] * [Weight])/3131)