square root function

[Jean Robinson]

I've tried to write an expression in a query to calculate
squareroot but access won't let me as SQRT is a worksheet
function. Does anyone know a way round this? - apart from
dumping access query result into excel and entering a
formula then importing back into access....

cheers,
jean

 

[Fredg]

Jean,
Answered in the GettingStarted newsgroup.

Please do not multi-post. If you feel you must post the same question to
several newsgroups (which is seldom necessary) crosspost, by adding each
newsgroup to the Newsgroups line separated by a comma. This way a reply in
any reply message is seen in all newsgroups, and all may learn from it.

Please read...
http://www.mvps.org/access/netiquette.htm

 

[Sean]

Hi

You can do two things you can use the SQR(value) function, or if you want
to find the n-th root of a number you can use (value)^(1/n). If you wanted
the cube root of 27 it would be: 3^(1/3).

Shawn

 

[Sean]

Sorry, typo that would be 27^(1/3).

Sean

Hi

You can do two things you can use the SQR(value) function, or if you want
to find the n-th root of a number you can use (value)^(1/n). If you wanted
the cube root of 27 it would be: 3^(1/3).

Shawn