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!
-
Determine sequential dates
I would need to count the days as one set of days taken off and exclude the holiday. See examples below. Example1: Friday holiday before taken 9/2 = 1 9/5 = 0 9/6 = 2 9/7 = 3 9/8 = 4 9/9 = 5 Example2: no previous day taken 9/5 = 0 9/6 = 1 9/7 = 2 9/8 = 3 9/9 = 4 no additional days taken...- noxidba
- Post #6
- Forum: Microsoft: Access Forms
-
Determine sequential dates
Thanks after a little tweaking that worked. The other issue I have is to account for holidays and not include in the count of days taken. For example if someone took off 9/2, 9/6, 9/7, 9/8, 9/9. Since 9/5 is a holiday they were really off 5 work days.- noxidba
- Post #4
- Forum: Microsoft: Access Forms
-
Determine sequential dates
Hello, I am needing to loop through records of employees with time take off dates and determine how many days off have been taken off in a row. For example, jDoe has dates 09/01/2016, 09/02/2016, 09/03/2016, 09/05/2016. I need to know that 3 days were taken off in a row. Below is the code and...- noxidba
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
