> Is there a way in CF that you can add the summ of all the results in a > certain query? I've never tried this, but you should be able to do this like so: <!--- get a list of all the values in the query column to sum ---> <CFSET lstVals = ValueList(qryQuery.yourColumn)> <!--- convert to an array ---. <CFSET arVals = ListToArray(lstVals)> <!--- now sum the array ---> <CFSET intYourSum = ArraySum(arVals)> Of course, you're better off letting the DB engine do this for you if that is at all possible. Regards, Seth Petry-Johnson Argo Enterprise and Associates ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
