why not use "Sum" (in Oracle) or some other aggregate function to do it with SQL?
>>> [EMAIL PROTECTED] 08/29/2005 12:18:28 PM >>> I wan't to subtotal column 'Amount' in my current dataset. I figure I need some kind of loop to go through each record but I just cant figure it out. I have a counter set up. Here is how I count the records. dsResults.Tables(0).Rows.Count Any help? Yahoo! Groups Links [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
