I need to build function that can created rotated shifts for 4 staff, that can be rotated every two days
3 shifts (7-3,3-11,11-7)
Day1 Day 2 Day 3 Day 4 Day 5 Day 7 Day 8 Day 9
Team 1 1 1 2 2 3 3 off Off
Team 2 2 2 3 3 off off 1 1
Team 3 3 3 off off 1 1 2 2
Team 4 off off 1 1 2 2 3 3
But we need to configure for each one what is his last shift (1 or 2 o r 3) before calculate because the current can be one of them
We should configure the start date when this should be apply
lets say the day 1 is 2/3/2014 then day 2 will be 3/3/2014
The second we need to save this in database and exported as excel sheet
Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…