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?