I would have thought that certainly for 12, it should have been sufficient to specify as update expression "COL1+COL2+COL3+....". I know it is kind of boring but it beats the export + conversion + import(or re-registration) procedure
Jacques Paris e-mail [EMAIL PROTECTED] MapBasic-MapInfo support http://www.paris-pc-gis.com -----Original Message----- From: Pclifton [mailto:[EMAIL PROTECTED] Sent: 30-Mar-04 20:47 To: Chong, Austin; Mapinfo-L (E-mail) Subject: Re: MI-L sum records against their columns I just did this with 40 columns of data and 9000 records. Couldn't figure out how to do it in MapInfo, so exported the .dbf, loaded into Excel and used the Summation function to get the row totals. Then exported back into a second .dbf and imported into MapInfo. Gary Clifton _____________________________________________________________ Great Basin Internet Services Webmail (http://greatbasin.net) ---------- Original Message ----------- From: "Chong, Austin" <[EMAIL PROTECTED]> To: "Mapinfo-L (E-mail)" <[EMAIL PROTECTED]> Sent: Wed, 31 Mar 2004 10:56:26 +1000 Subject: MI-L sum records against their columns > Hello all... > > I've got a very tricky question and I am not sure if its possible. I > have a table with about 50 records and each records have about 12 > columns worth of information. I just added one extra column called > "grand total". Now, I like to sum the column for the each records > and put the new value into the "grand total colum"... > > In short, its something like this > record 1 = value in column 1 + value in column 2 + value in column > 3 + value in column 4 + value in column 5 + .... > > and the final value into the grand total column. > > Many thanks in advance... > > Regards, > Austin ------- End of Original Message ------- --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11192 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11197
