There are a couple of ways you could go about this. I think the easiest way would be a VBA loop. Enter a start date and end date, loop from start to end and count the number of days for the employee in the loop. Are you comfortable with that? This would make a good TechHelp video. If not I could try to come up with a non-VBA solution.
Mandy DuncanOP
@Reply 18 months ago
Let me check out the VBA Loop series and get back with you. Currently, I can only do VBA with a video. Thank you.
Is this something you're looking to do just for one employee, or do you want to check a bunch of them?
Mandy DuncanOP
@Reply 18 months ago
It's for many contractors, about 150 total, but not all at the same time. Everyone is required to take a fatigue day on day 14. So, on day 12 or 13, I need a heads up so I can contact the appropriate people. I think day 12 is best just in case the DB Admin is fatiguing on day 13, understand?
Mandy DuncanOP
@Reply 18 months ago
Can it be done using the running total and tell it to reset when it finds a 2?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 28.