hey Deanna.
i figured it out..
was just the morning fog...
thanks..
-paul
<cfquery name="rsDisMonth" datasource="recycle">
SELECT Year(Offload_Date) as yearEnterd, Month(Offload_Date) as monthEnterd,
SUM(Offload_Gallons) AS SumGal
FROM tblOffload
GROUP BY Year(Offload_Date), Month(Offload_Date)
</cfquery>
<!--- Start our first part of a loop to order the results by the year they where
enterd. --->
<cfoutput query="rsDisMonth" group="yearEnterd">
<tr>
<td colspan="6"><strong>Total Sum for year #YearEnterd#</strong></td>
</tr>
<!--- Our second part of the loop orders by the month as well as adds up the total
gallons shiped out. --->
<cfoutput group="monthEnterd">
<tr>
<td align="right" valign="top"> </td>
<td align="right" valign="top">#MonthAsString(monthEnterd)#</td>
<td align="right" valign="top">#LSNumberFormat(SumGal,',99999999999999.99')#</td>
<td align="right" valign="top"> </td>
<td align="right" valign="top"> </td>
<td align="right" valign="top"> </td>
</tr>
</cfoutput>
</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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
