Hi all
I have table with the following fields:Driver_id, Date, Tag_in, tag_out, Driving time and various other numeric fields to summarize.The tag_in an tag_out fields are time_stamp fields.
Is it at all possible to create a summary which is grouped by driver_id and 24 cycle? Also to to have first tag_in and last tag_out fields for the 24 hour cycle. The reason for this is to see if a driver exceeded his / her driving time for a 24 hour cycle.I managed to to this on driver_id and date but this does not cater for when driver starts on 21h00 for a specific date and tag out at 04h45 the next day.Perhaps my approach to this is totally wrong.
Any suggestions would be appreciated.

Peter G