Grouping on Time Range

  • Thread starter Thread starter Michael Noblet
  • Start date Start date
M

Michael Noblet

I have a report that I need to group by 3 time
ranges.00:00:00 - 07:00:00 , 07:00:01 - 15:00:00,
15:00:01 - 23:59:99.

The time is a column in my report. Is there a way to do
this or do I need to build some sort of expression in a
query that will return a value for the 3 groups?
 
Michael said:
I have a report that I need to group by 3 time
ranges.00:00:00 - 07:00:00 , 07:00:01 - 15:00:00,
15:00:01 - 23:59:99.

The time is a column in my report. Is there a way to do
this or do I need to build some sort of expression in a
query that will return a value for the 3 groups?
Click to expand...


You need some kind of expression in either Sorting and
Grouping or the query. Depending on your other needs,
something like this Sorting and Grouping could do it:

=IIf(fldtime <= #7:00#, 1, IIf(fldtime <= #15:00#, 2, 3))
 
Back
Top