Square root function

[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

 

[Gregg]

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)

 

[Chris2]

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.

Jessica,

The function is titled SQR.


Sincerely,

Chris O.

 

[Jessica]

Thanks!

-----Original Message-----



Jessica,

The function is titled SQR.


Sincerely,

Chris O.



.