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