Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Counting and distributing absence days that span over months
I have an absence database which records the first day ([startdate]) and the last day ([enddate]) of an absence. I am able to count the length of the absence in days between these 2 dates ([nofda]) , having holidays and weekends discounted so we are left with just the workdays value. Now I...- JackDani
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
-
Form Filters and date ranges
My form has a series of text/combo boxes that allows filtering of staff records on criteria such as name, department, the first day of absence, the last day of absence, reason for absence and so on. I need to be able to show the absences for a department during a monthly period. I can set the...- JackDani
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
