Calculating in degrees only

[Guest]

I would like to add & subtract in degrees but have encoutered a problem in
that there is no format to support this calculation. This cannot be done in
decimal as 360 degrees is also 0 degrees. Example if the compass indication
is North this could be written as 000 or 360. If a calibration is taken & it
is found to be 001 then 000 should be used. If however it is 358 then 360
should be used. Due to another permutation the scenario could be that the
calibrator reads 358 and the compass reads 006. The actual deviation in this
case would be -8 , however in decimal it would calculate to 352 (358-002).

 

[Jeff Boyce]

Alfie

You might want to take a look at the MOD function. This might give you a
way to treat 360 as 0...

Regards

Jeff Boyce
Microsoft Office/Access MVP