it should make no difference how many records you have in your table. Dale's code will return the results you want.
Azadi Travis Haley wrote: > 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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289845 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
