If you want the date, And the date is the same per record, then just add it to the group by.
If the date is different per record then you need to either 1. Return multiple records 2. Use Max( or Min( on the date to get the oldest or newest Since your original sample had no dates, not sure what 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? 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:289888 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
