I hope someone can help me with this nasty problem.
This is a little result of a view. This is a dataset with duties of driver over a certain period. A driver cab start in the morning or in the evening around 22:00. So the time often pass the 00:00.
driverID is part of the condition
- Find the first record with activity signin. If found get date and time
- search with the given date and time the last record with activity sign out and get date and time
- everything between, including signin and sign out, date and time signin and date and time sign out is 1 driver duty
- the result of the query must show activity signin as the first record following by several activities en the last recods must be the activity signout
How can I do this?