Thank you that's good information I'll keep in mind. Marty
-----Original Message----- From: Uffe Kousgaard [mailto:[EMAIL PROTECTED] Sent: Thursday, July 28, 2005 10:50 AM To: Mapinfo-L Subject: Re: MI-L Query field properties Note on this: As soon as you apply the format$() function, the original full accuracy number is turned into a string with only 6 decimals and the rest is lost "for ever". As long as MapInfo shows the number with 3 decimals, the rest of them is still there behind the scenes and ready to be used in any calculation. Regards Uffe ----- Original Message ----- From: "Driver, Greg 9434" <[EMAIL PROTECTED]> To: "'Sprenz, Marty'" <[EMAIL PROTECTED]>; "Mapinfo-L" <[email protected]> Sent: Thursday, July 28, 2005 5:44 PM Subject: RE: MI-L Query field properties > You could use Format$() - > > format$((val(Mid$(LONGITUDE,3,3)) + (val(Mid$(LONGITUDE,6,7)) / 60 )) * > (-1), "#.######") > > Greg. > > -----Original Message----- > From: Sprenz, Marty [mailto:[EMAIL PROTECTED] > Sent: 28 July 2005 16:24 > To: Mapinfo-L > Subject: MI-L Query field properties > > > Is there a way to format the properties of a field in a query? The > function > that Uffe helped me with is great but it only goes out to the 3rd decimal > place. I need it to go to the 6th decimal place. > > > > Cingular Wireless > > Marty Sprenz (RF Engineer - Contractor) > > 100 Concourse Pkwy > > Birmingham, AL 35244 > > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > Office: 205-444-3572 > > Mobile: 404-509-9820 > > > > > > Internet communications are not secure and therefore Surrey Police does > not > accept legal responsibility for the contents of this message. This email > and any attachments may be confidential. They may contain privileged > information and are intended for the named addressee (s) only. They must > not > be distributed without our consent. If you are not the intended recipient, > please notify us immediately and delete the message and any attachments > from > your computer, do not disclose, distribute, or retain this email or any > part > of it. Unless expressly stated, opinions in this email are those of the > individual sender, and not of Surrey Police. We believe but do not warrant > that this e-mail and any attachments are virus free. You must therefore > take > full responsibility for virus checking. Surrey Police reserves the right > to > monitor all email communications through their networks. > > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17299
