I have a query called Today's Absence report, that will automatically list everyone who has requested time off that has been approved (or everyone that submitted sick leave). I want to be able to pull a list that show absences for today.
Ex: Joe Smith is off May 16th- 20th
Sally Student is off May 20th
Jane Doe is off May 20th-June 1st
John Doe is off June 1st-June 3rd.
I want the names to show up and drop off according to date only (even though on the form they can select a date and time). Is there a way to either default the time only or the best way to configure the query.
Below is the time off form and below that is the criteria on the query. Right now the query kind of works it drops off people because the time defaults to 12am.