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).

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


"Alfie" <(E-Mail Removed)> wrote in message
news:2914C897-33BC-4124-8626-(E-Mail Removed)...
>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).