square root function

  • Thread starter Thread starter Jean Robinson
  • Start date Start date
J

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
 
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
 
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
 
Sorry, typo that would be 27^(1/3).

Sean

Sean said:
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
Click to expand...
 
Back
Top