I have a resourcing database that lists the activities of a team of trainers and allows team managers to schedule work to the team. I have one member of the team however who does not work a Friday. I don’t want to have to schedule RDO (Rostered Day Off) every week so would like to run an update query that updates her activity every Friday to RDO.
I have a temporary query (Query1) that has the date of every Friday between now and January 2020
For every date on Query1 I would like to append a record on a table, tblResourcing that updates the following fields:
Start_Date – the date from Query1
End_Date – Same as start date
Duration = “All Day”
Trainer_Name = “Trainer Name”
Team = “Operational North”
Main_Activity = “RDO”
Activity = “RDO:”
I used to know how to do this but can’t remember for the life of me. Can anyone help?
I have a temporary query (Query1) that has the date of every Friday between now and January 2020
For every date on Query1 I would like to append a record on a table, tblResourcing that updates the following fields:
Start_Date – the date from Query1
End_Date – Same as start date
Duration = “All Day”
Trainer_Name = “Trainer Name”
Team = “Operational North”
Main_Activity = “RDO”
Activity = “RDO:”
I used to know how to do this but can’t remember for the life of me. Can anyone help?