Home>

### angle calculation on the access input form screen

I want to use unbound in the input form and calculate the angle.
The input form is as follows.

Add the first and second lines, then subtract 360 degrees
I want to automatically enter the third line.
Example
89 ° 58'20 "+ 270 ° 01'30" -360 ° =-0 ° 0'10 "
90 ° 04'30 "+ 268 ° 55'25" -360 ° =-0 ° 0'05 ​​"

When calculating the angle adjustment in this way, replace the angle with time.
Will it be a way to calculate?

Please give me some advice.

• Answer # 1

Name the corner text boxes for degrees, minutes, and seconds as follows.

deg1 min1 sec1

deg2 min2 sec2

deg3 min3 sec3

Also, add three text boxes for total calculation and name them as follows.

secSum1 secSum2 secSum3

Add a text box for negative display and name it sgn3.

Set the control source of each text box as follows.

secSum1`= [deg1] * 3600+ [min1] * 60+ [sec1]`
secSum2`= [deg2] * 3600+ [min2] * 60+ [sec2]`
secSum3`= [secSum1] + [secSum2]-360 * 3600`

sgn3`= IIf (Sgn ([secSum3]) =-1, "-", "")`
deg3`= Abs ([secSum3] \ 3600)`
min3`= Abs (([secSum3] \ 60) Mod 60)`
sec3`= Abs ([secSum3] Mod 60)`

Since secSum1, secSum2, and secSum3 are for calculation, set "Visible" to "No" to hide them.

that's all.