Link to home
Start Free TrialLog in
Avatar of Wade Abbott
Wade Abbott

asked on

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

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
Avatar of Arana (G.P.)
Arana (G.P.)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Wade Abbott
Wade Abbott

ASKER

OK, you say I can paste the code in my vba editor and run it as a function....I have no idea what that means.
From the form design view, where do I paste the code? And then?
@crystal I see one function is convert_decimal and the other is convert_degree, dont see the same name anywhere, or I am missing something.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
question answered to Convert decimal degrees to degrees/minutes/seconds