I am afraid not. A spreadsheet is the right tool for that job, not a database. Sorry!
Of course you could always script your own solution (calculating running totals, etc.) Best Wishes, Shawn Green Database Administrator Unimin Corporation - Spruce Pine [EMAIL PROTECTED] wrote on 08/13/2004 06:29:18 PM: > Hi, > I would like to use SUM or any other function to sum a series of > records as in the following example. > > I have this table T1 > > Col1 Col2 > 1 20 > 2 10 > 1 10 > 2 5 > 1 20 > 3 10 > > and would like to obtain this result from a query > > Col1 Col2 Col3 > 1 20 20 > 1 10 30 > 1 20 50 > 2 10 10 > 2 5 15 > 3 10 10 > > Column Col3 should carry forward and sum values from Col2 > > Is that possible ?, with SQL I mean... > > > Thank you > Mauricio > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >