does anyone have any idea on how i can create a daily time record of an employee on a grave yard shift? say from 11PM-7AM.

i have a table with these sample data,

swipedate  time
04/01/2003 2210
04/02/2003 0730
04/02/2003 2245
04/03/2003 0701
04/03/2003 2250
.
.
.
.

the report should look like this,

   date       timein     timeout
04/01/2003    22:10      07:30
04/02/2003    22:45      07:01
04/03/2003    22:50