Yes that works if there is only these three entries in the database however there are more than three here is a full sample of data
Check_Num, Issued_To, Amount 1234, Travis, 100.00 1234, Travis, 1.00 1234, Travis, 6.00 1235, Kim, 300.00 1235, Kim, 6.00 1236, Adam, 100.00 1237, Travis, 200.00 How can i get the values returned to be Check_Num, Issued_To, Amount 1234, Travis, 107.00 1235, Kim, 306.00 1236, Adam, 100.00 1237, Travis, 200.00 Sorry for the lack of information earlier Travis ---------------------------------------- From: "Dale Fraser" <[EMAIL PROTECTED]> Sent: Monday, October 01, 2007 12:56 AM To: CF-Talk <cf-talk@houseoffusion.com> Subject: RE: Adding Small sections of a query 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
