troubleshooting Question

Convert decimal degrees to degrees/minutes/seconds in MS Access

Avatar of Wade Abbott
Wade Abbott asked on
Microsoft Access
6 Comments3 Solutions512 ViewsLast Modified:
In the MS Access Form, I need to use and convert a decimal degree in one field to populate a second field showing degrees/minutes/seconds (DMS)

For example I need the following:
I enter in Field LATITUDE = 46.12365, I need Field LATITUDE DMS to populate with 46° 07’ 25.14”
I enter in Field LONGITUDE = -85.12365, I need Field LONGITUDE DMS to populate with 86° 52’ 34.86”

The DMS fields can be either 1 field showing the DMS or a series of 3 fields showing the D, the M and the S….doesn’t matter
I am using MS Access 2013
ASKER CERTIFIED SOLUTION
Arana (G.P.)

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros