> Do I need to do some kind of a loop to get the subtotals for each > account? Thanks.
There are a few ways to do it. One option is to use a variable to accumulate the subtotals within your inner cfoutput. <cfoutput query="GetCostSum" group="Acct"> <strong>#Acct#-6405</strong><br /> <cfset subtotal = 0> <cfoutput> #Name# #DollarFormat(Cost)#<br /> <cfset subtotal = subtotal + cost> </cfoutput> Total: #DollarFormat(subtotal)#<br /><br /> </cfoutput> Another option is to use a derived query to calculate the subtotals in your sql. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315398 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4