> 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

Reply via email to