Grouping records by time duration greater then 4,12,18,24 hr etc.

[dzavad]

I have a hard time to figure out how to group records by the time duration greater then 4 hr, 12 hr,18, 24, 36, ..etc. The trick is to have records in each group if time duration exids one group:
Example:
Customer1 time duration =10 hr should be displayed in group 4 hr and group 12 hr.
Castomer2 time duretion= 30 hr should be displayed in group 4 hr and group 12 hr and the group 18 hr and the group 24 hr.

 

[Ngolem]

give us a sample of what the report should look like Jim Broadbent

 

[dzavad]

LIST CUSTOMERS OUT OF SERVICE
From: 9/1/02 To: 9/3/02

TIME DURATION FROM 4 HR TO 8 HR
-------------------------------------------------
CUSTOMERS DURATION
-------------------------------------------------
ROBERT RICH - 10hr
KLINE RUSSELL - 5.1hr
LARNON ELIZABETH - 7.4 hr
...............
...............

TIME DURATION FROM 8HR TO 12HR
------------------------------------------------------
CUSTOMERS DURATION
------------------------------------------------------
ROBERT RICH - 10hr
HILLEY ALICE - 9hr
FOWLER NORMAN - 8.5hr
GEORGE CRAIG - 11.2 hr
.....................
....................