How about using the Year(), Month(), and Day() functions against the field and sort on those. Use year as the major, month as the intermediate, and day as the minor.
Ray Thompson Systems Administrator Tau Beta Pi Association www.tbp.org The Engineering Honor Society Integrity and Excellence in Engineering > -----Original Message----- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Friday, September 12, 2003 11:04 AM > To: CF-Talk > Subject: grouping a query on date > > > Hi, > > I have a table with a date/time field in an Access database. > I want to have a query grouped on the date, with no regard to > time, so that all records from the same day are grouped. I > need a function (in SQL-Access) that will extract the day > part of a date/time value, in a form that is still suitable > for sorting, and I connot find any one. > > I tried LEFT(mydate, 8), but it generates a date like > mm/dd/yy not suitable for sorting. What I need is the date of > the day in true date format, not as a string. > > Any idea ? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
