You'd probably have to be a bit more specific to get real solid answers. You can, for example, treat a query like an array and sum a column. <cfset mytotal = arraysum(myquery[mycolumn])>
You can sum row data across columsn <cfset mytotal = myquery.mycolumn[1] + myquery.myothercolumn[1]> If you can give us more info about what you want to accomplish, we can probably help you out. You can loop through a query and sum things along the way, too. So, what are you really trying to do? On 2/9/07, Michele Michele <[EMAIL PROTECTED]> wrote: > Hi- > I am not a proficient CF programmer, just got pushed into it. I need to add > up fields brought in from a sql statement, various totals from different > columns, and output them along with the individual column totals. Is there > any way at all I can do this? I bet this sounds amatuer and trust me it is. > Please take pity on me if someone out there can tell me! > > Thanks, > Michele > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269332 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
