Converting Lat. Long

bolson7117

Registered User.
Local time
Today, 16:46
Joined
Sep 1, 2009
Messages
42
Hey guys,

I'm trying to get a GPS format from this:

Table:ENGB (AMI GPS) Part 2
Latitude:41.58932000
Longitude:-96.92073000

To this:
Table:ENGB (AMI GPS) Part 2
Latitude:4158932000
Longitude:9692073000-

Thanks in advance :), I know the table name has spaces, don't hate me :o
 

Attachments

  • exp1.jpg
    exp1.jpg
    23 KB · Views: 107
It looks like the field format is Text
 
Use the instr() function to find the location of the ".", do some simple math, split the text using the left and mid functions then put it back together again... I would write the code for you but you'll learn more if you do it yourself, maybe google 'ms access intr()', etc
 
Yea I've been giving it a whack for a bit now, ill try and get it. It's prob something simple.
 
Post what you tried - maybe someone can help...
 
This site is a good source for how Access functions work:

http://www.techonthenet.com/access/functions/

The first section has the String functions which are what you need. My advice would be to write out step by step instructions for how you would explain what you need done to a 3rd grader:

Step 1: Remove the decimal from the string
Step 2: Move a negative sign to the end
Step 3:...
Step 4:...

Then build a function inside a module that accomplishes each step and returns the final product.
 
What exactly is the rationale for this final format?
Latitude:4158932000

Could you please tell readers WHAT you are trying to accomplish in plain English?
 

Users who are viewing this thread

Back
Top Bottom