ok i am having a slight brain fart.
have left my reference books at home
i want to loop through year, grouping by month & displaying sum total.
right now i have it grouping by month & displaying sum total, but it lumps the year
together..
should be simple, and i have search archives..
thanks
-paul
<cfquery name="rsDisMonth" datasource="recycle">
SELECT Year(Month(Offload_Date)) as yearEnterd, Month(Offload_Date) as monthEnterd,
SUM(Offload_Gallons) AS SumGal
FROM tblOffload
GROUP BY Year(Month(Offload_Date)), Month(Offload_Date)
</cfquery>
<cfoutput query="rsDisMonth" group="monthEnterd">
<tr align="right" valign="top">
<td>#YearEnterd#</td>
<td>#monthEnterd#</td>
<td>#LSNumberFormat(SumGal,',99999999999999.99')#</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
