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...
 
Top