Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Grouping by Hour doesn't work!!
dhookom Thanks, sorting on Hour([Time]) - Each Value worked fine. In regards to the other questions, I am using [process time] as my time field. I am using Access 2000 I think (i'm not at work right now). I'm glad it wasn't just me having this issue. Cheers Joel- jolby
- Post #8
- Forum: Microsoft: Access Reports
-
Grouping by Hour doesn't work!!
Ken Format doesn't seem to have any effect on the way it is grouping. dhookom There isn't any other levels of sorting. At first I was running my report off a query that selected a range of dates and times, when I first noticed it. But I have also tried it with some sample data in a table with...- jolby
- Post #6
- Forum: Microsoft: Access Reports
-
Grouping by Hour doesn't work!!
Given The sample Input, with Time as a Date/Time field with format "Short Time" IDA Quantity Date Time 0112843 40 30/05/2005 08:28 0112844 40 30/05/2005 08:37 0112845 40 30/05/2005 08:39 0112847 40 30/05/2005 08:46 0112849 40 30/05/2005 08:52 0112850 40 30/05/2005 09:01 0112851 40...- jolby
- Post #3
- Forum: Microsoft: Access Reports
-
Grouping by Hour doesn't work!!
Whenever I select group by hour in sorting and grouping, it returns a split between two hours. I.e. it would group between 7.30 and 8.30, instead of between 7.00 and 7.59. Is there any way to fix this? Cheers Joel- jolby
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
