Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    13

    Unanswered: using a formula with exponents in a query

    Hi, I have a table that contains 4 fields that I want to use in a formula. The 4 fields are: serum creatinine, age, race, and gender.
    The formula is:
    eGFR= 186 * ([serum creatinine]E-1.154) * ([age]E-0.203) * (1.21 if [race]=1) * (0.742 if [gender] = 1)
    The Es in that formula represent exponents.
    I just want to use an expression in a query to calculate this formula but I don't know how to show the exponents. Can anyone help?

    Thanks!
    anna

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Are you looking for the ^ operator?

    ?3^4
    81
    Paul

  3. #3
    Join Date
    Jul 2009
    Posts
    13
    Yes! I finally figured that out after I posted and my formula is working fine. It was so simple really....

    Thanks for your help.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    No problem, and welcome to the site!
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •