SQRT formula

[Ann]

The Excel sheet I am importing into Access contained a
calculated column =SQRT(((L4/57.3)^2)-(0.00356)^2. In
Access, if I try to simply have a text box with =SQRT
((([BWH]/57.3)^2)-(0.00356)^2) I get a ?Name result. Isn't
the square root function recognized by Access?

 

[Allen Browne]

The formulae are different.
In Access it's called Sqr().

 

[Ann]

Thanks Allen.

-----Original Message-----
The formulae are different.
In Access it's called Sqr().

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

The Excel sheet I am importing into Access contained a
calculated column =SQRT(((L4/57.3)^2)-(0.00356)^2. In
Access, if I try to simply have a text box with =SQRT
((([BWH]/57.3)^2)-(0.00356)^2) I get a ?Name result. Isn't
the square root function recognized by Access?

.