Square Root?????

  • Thread starter Thread starter Susy
  • Start date Start date
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
 
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 ;-)
 
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...
 
Back
Top