Square Root?????

S

Susy

Help! Is there no square root function in Access 2000? I
get "undefined function" for the following formula:

L: SQRT[ASTMDepth]/[ElapseTime])*[ASTMK]

I'd SWEAR I used square root in Access 97....

Thanks
 
M

Marshall Barton

Susy said:
Help! Is there no square root function in Access 2000? I
get "undefined function" for the following formula:

L: SQRT[ASTMDepth]/[ElapseTime])*[ASTMK]

I'd SWEAR I used square root in Access 97....
Click to expand...


It's spelled SQR ;-)
 
J

John Spencer (MVP)

Also you can get the n-th root by using

^(1/N) so

8^(1/3) = 2

You do need the parentheses to enforce the order of operation.

Marshall said:
Help! Is there no square root function in Access 2000? I
get "undefined function" for the following formula:

L: SQRT[ASTMDepth]/[ElapseTime])*[ASTMK]

I'd SWEAR I used square root in Access 97....
Click to expand...

It's spelled SQR ;-)
Click to expand...
 

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

Similar Threads

**C++ PROGRAMMING PROBLEM ** 1
Square root function 3
locate square root symbol (not words) 4
Using user function (vba) with sqrt(array)-only first answer 1
How to calculate a square root in a query 3
what is formula for cubed root 2
what is the formula for the cubed root of 1
find the largest value in column, put in a cell 1

Top