Hi Guys
My challenge is to quarterly allocate various activities (e.g Call audits, Staff reviews,meetings etc..) for the staff members. Sometimes there are 2 or 3 activities to be taken place quarterly for the some of the staff members.
So I have done the following and need your help in updating the 'MonthRef' field.
I have inserted few records for the staff members in a table and now I want to run update query that will pick first 55% of the records and update 'MonthRef' field to first quarter of the year (i.e Jan) and then it will update 55% of the remaining records and 'MonthRef' field is set to 'May' . And then it will update the remaining records in the table and the 'MonthRef' field is set to 'Sep'.
This is the first alternative to get this done, the other one could be using Random function and update 'MonthRef' field.
Can anyone please help me in this?
Regards,
My challenge is to quarterly allocate various activities (e.g Call audits, Staff reviews,meetings etc..) for the staff members. Sometimes there are 2 or 3 activities to be taken place quarterly for the some of the staff members.
So I have done the following and need your help in updating the 'MonthRef' field.
I have inserted few records for the staff members in a table and now I want to run update query that will pick first 55% of the records and update 'MonthRef' field to first quarter of the year (i.e Jan) and then it will update 55% of the remaining records and 'MonthRef' field is set to 'May' . And then it will update the remaining records in the table and the 'MonthRef' field is set to 'Sep'.
This is the first alternative to get this done, the other one could be using Random function and update 'MonthRef' field.
Can anyone please help me in this?
Regards,