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
