mshmyob, I understand that this is a VERY old thread although it is very close to what I have been trying to do for quite a while. I am simply trying to automate a call center schedule using Access and while I have some good knowledge of Access and a very little bit of VBA what you have done here is very close. I have been trying to modify your code a little bit to be able to put "# of employees needed" for each individual shift. I have...