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
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
Microsoft Access
Last Comment
crystal (strive4peace) - Microsoft MVP, Access
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
@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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
question answered to Convert decimal degrees to degrees/minutes/seconds
From the form design view, where do I paste the code? And then?