Square root function

  • Thread starter Thread starter Jessica
  • Start date Start date
J

Jessica

Greetings!

I want to calculate Standard error in an access query
based on the following formula:

(Stdev)/(square root (total records))

When I try the Access sqrt function I get the following
error message: Undefined function sqrt in expression.

Is there a way to calculate square root in a query. All
the parameters needed for the formula are there, I just
need to be able to take the square root of a number.
Currently I have to export my data to excel where I am
able to calculate square root and therefore standard error.

Any help would be appreciated!

Jessica
 
Jessica,

You could use a fractional exponent for this. The carat
(^) indicates an exponent, so to take a square root it
would be ^(1/2). For example, the calculated field in your
query might look like:

FIELD1SQRT: ([FIELD])^(1/2)
 
Jessica said:
Greetings!

I want to calculate Standard error in an access query
based on the following formula:

(Stdev)/(square root (total records))

When I try the Access sqrt function I get the following
error message: Undefined function sqrt in expression.
Click to expand...

Jessica,

The function is titled SQR.


Sincerely,

Chris O.
 
Back
Top