Converting GPS coordinates to decimal in Report


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