Query to group data by shifts

[shavon]

Hello:

I would like to make a query that groups data by shifts. We collect production stats. The shifts are as follows:
23:00 to 07:00, 07:00 to 15:00, 15:00 to 23:00. As you can see, the night shift overlaps. How can I write a query to group so that the night employees do not get two entries per day? Thank you.

 

[traingamer]

Not enough information.
What fields are in your tables? Is the night shift grouped on the starting day or the next day? Give us some sample data and some sample expected output.
Thanks.

traingamer