I have created a report that feeds off of a query and a date form, basically a user types in the date in a date form that triggers a report to shoot off with the appropriate info for that day. The problem that I have come across is that the users also want to break the report down into 3 sections to represent the shift times, Morning=5am to 12pm, Afternoon=12:01pm to 5pm, Evening=5:01pm to 4:59am. I thought about using option buttons on this but I think that might be more complicated. As it stands I have to put the user in this also to further break it down.
Date______
User______
Shift
Morning___
Afternoon___
Evening___
Exit OK
I am pulling from a query that has all the correct info, date, time, etc...
Is there an easy way to make this happen?
Date______
User______
Shift
Morning___
Afternoon___
Evening___
Exit OK
I am pulling from a query that has all the correct info, date, time, etc...
Is there an easy way to make this happen?