goatbar (goatbar) wrote,

  • Location:
  • Mood:

MS Access - Degrees and Decimal Minutes to Decimal Degrees

I have what I think is a fairly simple problem in MS-Access, yet I can't quite seem to figure out how to do this. In a geospatial database, I would like to just store decimal degrees in the database, but I would like to have a form that allows entering either decimal degrees or ... degrees and a separate decimal minutes (as you would see on a typical GPS display).

I'm a beginner at MS-Access and I've got the 2002 version. I tried setting an Expression in the Expression Builder, but it seems that Access is unhappy that LatDeg and LatMin are not in the database.

Can anyone help me out here?

Tags: microsoft

  • Post a new comment


    default userpic
    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 1 comment