Square Root Function In Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to do a square root and I want the value of that calculation to be displayed in a text box. I'm using values in 4 other text boxes to do the calculation. Below is what I have and it's not working.

Private Sub Command79_Click(
Dim mysqr As Doubl
Dim dp As Intege

mysqr = Sqr(((Text32.Value) - (Text72.Value) ^ 2 + (Text34.Value) - (Text74.Value) ^ 2) / 10

mileage = Int((x * 10 ^ dp) + 0.5) / 10 ^ d

Text77.Value = mileag
End Su

I know what I'm doing wrong is probably a simple thing but I can't figure it out. Any help is appreciated

Thanks

Kevin G
 
Kevin,

Can you expand upon the meaning of "it's not working"?

Also, I notice you haven't assigned a value to the dp. Nor is it clear
what the meaning of "x" is. Nor is it clear how the code relates to
your question, since mysqr is not implicated at all in the assignement
of the value to Text77.
 
Back
Top