Square root function


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
 
Ad

Advertisements

G

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

Chris2

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.

Jessica,

The function is titled SQR.


Sincerely,

Chris O.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top