Hi Austin, I would have thought you could use the 'Update Column' function and use an expression such as 'Column 1 + Column 2 + etc...' as the value to set the grand total column to.
Keith -----Original Message----- From: Chong, Austin [mailto:[EMAIL PROTECTED] Sent: 31 March 2004 01:56 To: Mapinfo-L (E-mail) 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 This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11196
