Re: Body Surface area code

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)));


"John Nurick" wrote:

Can you show us the SQL of the query?

On Sat, 23 Dec 2006 20:19:00 -0800, RobUCSD
<RobUCSD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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

"Douglas J. Steele" wrote:

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
http://I.Am/DougSteele
(no private e-mails, please)


"RobUCSD" <RobUCSD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2C4E8FFA-08B7-415A-83EB-027258CA15E6@xxxxxxxxxxxxxxxx
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

"Douglas J. Steele" wrote:

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
http://I.Am/DougSteele
(no private e-mails, please)


"RobUCSD" <RobUCSD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2AA97C9D-7C42-4479-AC59-A2C99F33A984@xxxxxxxxxxxxxxxx
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

"John Nurick" wrote:

On Fri, 22 Dec 2006 19:47:00 -0800, RobUCSD
<RobUCSD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:


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

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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.








--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

.

Relevant Pages

  • Re: Text file I/O in VBA
    ... "John Nurick" wrote: ... Input #1, strLIne ... John Nurick [Microsoft Access MVP] ... Please respond in the newgroup and not by email. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Export Fixed Width Data Error
    ... John Nurick [Microsoft Access MVP] ... Please respond in the newgroup and not by email. ... Prev by Date: ...
    (microsoft.public.access.externaldata)
  • Re: Body Surface area code
    ... "John Nurick" wrote: ... The SQL you posted will return all records from tblClinicalPresentation ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: how do I import a MS Word Template to MS Access as a form?
    ... ability to edit the original template. ... John Nurick [Microsoft Access MVP] ... Please respond in the newgroup and not by email. ...
    (microsoft.public.access.externaldata)
  • Re: Text file I/O in VBA
    ... On the advanced tab, the save and specs.. ... "John Nurick" wrote: ... John Nurick [Microsoft Access MVP] ... Please respond in the newgroup and not by email. ...
    (microsoft.public.access.modulesdaovba)
Loading