A table (Referral_Action in SQL Server 2000) has Action_Item as below along with the date of action.
Carried Over (let say CO) Client/Family Cancelled (CC) Home Assessment (HA) Other (OT) Referred Other Agency/Service (RO) Volunteer Assigned (VA) The query will be <cfquery name ="foo" ….> Select Action_Item, datepart (mm, Action_Date), count (Action_Item) >From Referral_Action Group by Action_Item, datepart (mm, Action_Date) Order by Action_Item, datepart (mm, Action_Date) </cfquery> The cfoutput has to show in a char format. The month (from Jan to Dec) should show up from left to right on the top Action_Item should show up from to bottom on the left At the bottom, the total count of each month should show up. The display should look like below. ------ Jan Feb etc CO 2 3 CC 2 2 HA 3 0 OT 5 1 RO 6 6 VA 1 2 Total 19 14 Please advise how to accomplish this. TIA, Daniel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195060 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
