I work in a security office. I have to track the daily operations of each employee by date and time. I have a table called DaiyLogT with three fields: Date (MM/DD/YYYY), Time (HH/NN), Incident (long text). also DailyLogID as the primary key.

I need to generate a report showing this, but I can't seem to make a query to work. One Shift is Graves from 23:00 to 07:00 the next day.

The boss just wants to see a report covering the daily activity of each shift by itself.