Hi Peter - add the new column as float - run table / update column and specifiy "colxx-771.49"
Mit freundlichem Gruss / Best Regards Flavio Hendry ---------------------------------------------------------------- TYDAC NEWS http://www.tydac.ch/german/index.php?menu=News_actual ---------------------------------------------------------------- ############ Mit freundlichen Gruessen / Kind Regards ############ mailto:[EMAIL PROTECTED] ############ TYDAC AG - http://www.tydac.ch #### #### Geographic Information Solutions #### #### Luternauweg 12 -- CH-3006 Bern ############ Tel +41 (0)31 368 0180 - Fax +41 (0)31 368 1860 ---------------------------------------------------------------- -----Original Message----- From: "Peter Hatton" <[EMAIL PROTECTED]> To: <mapinfo-l@lists.directionsmag.com> Date: Fri, 10 Mar 2006 17:02:55 +1000 Subject: [MI-L] SQL QUERY > > > Hi all, > can someone help me > with the following .......... I am having a memory blank ........ I > have a float column containing a certain value ...... what I want to > do is subtract the mean of the total of all of the values from each > value and record in a new column of the table ....... I've worked out > the mean value (771.49) ............. Can someone point me in the > right direction ............ > > Many thanks ...... > > Regards > > Peter > > > Peter HATTON > GIS Officer > Greater Taree City Council > 2 Pulteney Street TAREE 2430 > phone 02 6592 5227 > e-mail [EMAIL PROTECTED] gov.au > > This email and any files transmitted with it are intended solely for > the use of the individual or entity to whom they are addressed. > Greater Taree City Council is a government organisation and is > subject > to Freedom of Information legislation. You must assume that any > material sent to Greater Taree City Council may be accessible by > persons other than the intended recipient. > The contents of this message may express views and opinions > not necessarily shared by Greater Taree City Council. > > This e-mail has been scanned for viruses by MCI's Internet Managed > Scanning Services - powered by MessageLabs. For further information > visit http://www.mci.com _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l