SQRT formula

  • Thread starter Thread starter Ann
  • Start date Start date
A

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?
 
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?
Click to expand...


.
Click to expand...
 
Back
Top