Hello. Say I have a table with the following data:
Acct#, Name, Cost
001, Bennett, 50.00
001, Bradley, 250.00
001, Green, 200.00
420, Smith, 50.00
420, Cummings, 50.00
470, Brown, 80.00
I would like the output to be like:
001-6405
Bennett 50.00
Bradley 250.00
Green 200.00
Total 001 500.00
420-6405
Smith 50.00
Cummings 50.00
Total 420 100.00
470-6405
Brown 80.00
Total 470 80.00
Total Accts 680.00
I used a query like this
<cfquery name="GetCostSum" datasource="travel">
SELECT SUM(Cost) AS CostSum, Acct, Name, Cost from travel WHERE
reconciled = 'No' GROUP BY Acct, Name, Cost
</cfquery>
to try and get the groups summed up together, but my sum total is only the
first record so it looks like the following. The output is:
<cfoutput query="GetCostSum" group="Acct">
<strong>#Acct#-6405</strong><br />
<cfoutput>
#Name# #DollarFormat(Cost)#<br />
</cfoutput>
Total: #DollarFormat(CostSum)#<br /><br />
</cfoutput>
001-6405
Bennett 50.00
Bradley 250.00
Green 200.00
Total 001 50.00
420-6405
Smith 50.00
Cummings 50.00
Total 420 50.00
470-6405
Brown 80.00
Total 470 80.00
Do I need to do some kind of a loop to get the subtotals for each account?
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:315387
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
