Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

From latitud and longitude to dec

Status
Not open for further replies.
seoman

seoman

Technical User
Dec 19, 2001
1
ZA
Does any one know how to transform latitude and longitude to decimal when using Acess.
 
Sort by date Sort by votes
If I understand your question, you need to seperate out the Degrees, Minutes and Seconds parts of the Long or Lat. The formula is then

Degrees + Minutes/60 + Seconds/3600
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
139
mmiah1982
mmiah1982
Bill Doe
  • Locked
  • Question
PDO UPDATE too long to execute
Replies
1
Views
134
mikrom
mikrom
fredong
  • Locked
  • Question
Update upper row data with next row data that was detached partially from import.
Replies
6
Views
183
carp
carp
cristianivanoff
  • Locked
  • Question
Calculating amount from transactions...
Replies
1
Views
123
fredericofonseca
fredericofonseca
mikrom
  • Locked
  • Question
from a table with symmetric relation select every pair only once
Replies
0
Views
95
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top