Converting GPS coordinates to decimal in Report

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007,reports,VBA 2
Converting URLs in comments to Markdown-formatted links 2
Excel does not accept text format! 0
Report Group Footer DLookUp 0
Weekly Report 2
GPS Coordinates 3
Converting Lat/Lon coordinates to Decimal 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top