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 Rhinorhino 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
Joined
Dec 19, 2001
Messages
1
Location
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 Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
563
mmiah1982
mmiah1982
Bill Doe
  • Locked
  • Question Question
PDO UPDATE too long to execute
Replies
1
Views
552
mikrom
mikrom
fredong
  • Locked
  • Question Question
Update upper row data with next row data that was detached partially from import.
Replies
6
Views
827
carp
carp
cristianivanoff
  • Locked
  • Question Question
Calculating amount from transactions...
Replies
1
Views
533
fredericofonseca
fredericofonseca
mikrom
  • Locked
  • Question Question
from a table with symmetric relation select every pair only once
Replies
0
Views
439
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top