Select Check_Num, Issued_To, sum(Amount) as Total >From TableName Group by Check_Num, Issued_To Order by Check_Num, Issued_To
Regards Dale Fraser http://learncf.com -----Original Message----- From: Travis Haley [mailto:[EMAIL PROTECTED] Sent: Monday, 1 October 2007 4:43 PM To: CF-Talk Subject: Adding Small sections of a query I am not sure the best way to phrase this question but I'll try here. I have a table that records checks I am breaking the check down in the database to show where each dollar goes so I have 3 lines with the same check number Example: Check_Num, Issued_To, Amount, Expense_Type 1234, Travis Haley, 100.00, 203 1234, Travis Haley, 6.00, 207 1234, Travis Haley, 21.00, 213 This is done to allow me to run a report on expense type and get what I need to pay in taxes. (I hate taxes lol) Anyway now that I'm trying to make a General Ledger I am trying to combine these back together using SQL I was wondering if there is a way to do this? I want the query to have one line with 1234, Travis Haley, 127.00 Expense_Type is not needed for this report Thanks in advance, Travis Haley ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
