I have a date/time field i.e. (3/14/2007 6:00:00 am) and I need to be able to group number of records by hour in a report. I did the Group On hour etc. during the design wizard and it looks like it did fine, with a group title for 6am, then 7am etc. Just what I needed. However, it's not totally accurate, and keeps adding another group header, so I will have two 6am headers and two 7am headers, rather than just one. Any ideas? thanks.
