Converting GPS coordinates to decimal in Report

  • Thread starter Thread starter Jeff Joyner
  • Start date Start date
J

Jeff Joyner

I have an Access 2007 database that has a table that contains GPS information in the format degrees° minutes' and seconds". In a report, I want to read this field and, using a unbound text box, convert it to decimal notation (degrees.xxxxx). I have found the VBA code that should do this, but it's not working and I don't know how to invoke this on every record in the report. In addition, would it be easier to do this some other way?

Any ideas or suggestions?
 
Back
Top