Crap, it goes back to my stupid date/time datatype for the field. All the times are different, and CF IS group the data, but they're all different so it output each row. I used Michael's example from my other thread to do this. Seems to work:
SELECT estshiplogid,CAST(FLOOR(CAST(estshiplogdate AS float)) AS datetime) AS theDate, estshippostalcode FROM tblestshiplog ORDER BY estshiplogdate DESC Then I just group using theDate. Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4