Grouping on Time Range

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 Noblet wrote:

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?


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))
--
Marsh
MVP [MS Access]