RE: Adding Small sections of a query

: Tuesday, 2 October 2007 3:37 PM To: CF-Talk Subject: RE: Adding Small sections of a query The date part of the datetime is the same the time part differs but the time part is irrelevant to this report. I was able to get this to work by dropping the date out of the first query then running a second

RE: Adding Small sections of a query

-Talk Subject: RE: Adding Small sections of a query Select Check_Num, Issued_To, sum(Amount) as Total, max(purDate_Purchased) as PurchaseDate From TableName Group by Check_Num, Issued_To Order by Check_Num, Issued_To Easy! Regards Dale Fraser http://learncf.com -Original Message- From

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,

RE: Adding Small sections of a query

: 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

RE: Adding Small sections of a query

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

Re: Adding Small sections of a query

, 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

RE: Adding Small sections of a query

: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Monday, October 01, 2007 2:56 AM To: CF-Talk Subject: Re: Adding Small sections of a query it should make no difference how many records you have in your table. Dale's code will return the results you want. Azadi

Re: Adding Small sections of a query

Remove the date from the query. On 10/2/07, Travis Haley [EMAIL PROTECTED] wrote: Thanks for all the help so far I know I'm almost there I figured out that all the items in the select need to be in the group by clause, however what is causing the problem is the date. When I run the query

RE: Adding Small sections of a query

But I need the date, should I run this in a second query? Travis Haley -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, October 01, 2007 6:45 PM To: CF-Talk Subject: Re: Adding Small sections of a query Remove the date from the query

Re: Adding Small sections of a query

: Monday, October 01, 2007 6:45 PM To: CF-Talk Subject: Re: Adding Small sections of a query Remove the date from the query. ~| Check out the new features and enhancements in the latest product release - download the What's

Re: Adding Small sections of a query

Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, October 01, 2007 6:45 PM To: CF-Talk Subject: Re: Adding Small sections of a query Remove the date from the query. ~| Create robust enterprise

RE: Adding Small sections of a query

you are referring to. Regards Dale Fraser http://learncf.com -Original Message- From: Travis Haley [mailto:[EMAIL PROTECTED] Sent: Tuesday, 2 October 2007 11:28 AM To: CF-Talk Subject: RE: Adding Small sections of a query But I need the date, should I run this in a second query

RE: Adding Small sections of a query

BY. Travis Haley -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, October 01, 2007 7:38 PM To: CF-Talk Subject: Re: Adding Small sections of a query Which date do you want? You have multiple entries - which one should the query return? On 10/2/07, Travis Haley [EMAIL