Hello again, I'm getting a data type mismatch error with the following sql statement: ((Mid$(LONGITUDE,3,3)+(Mid$(LONGITUDE,6,7)/60))*-1) "LONGITUDE". I broke down the statement and the problem is to the right of the plus sign. The value of the field looks like this: W 11521.0460. I need to get rid of the W then add the 115 to the equation of (21.0460 / 60) then multiply all of that by -1. (115+(21.0460 / 60))*-1. Any solutions? Why does this sql statement work in every program I've ever used that accepts sql statements but not in MI. Does it use some different form of sql?
Thanks in advance, Marty Sprenz (RF Engineer - Contractor) 100 Concourse Pkwy Birmingham, AL 35244 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Office: 205-444-3572 Mobile: 404-509-9820
