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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289841 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4