Recent content by fraufreda

Hi I would like to be able to assign specific employee to specific shift. like for example: assign Employee A to either morning or evening shifts but not night. I don't know if this can be done through a query or using macro. I would appreciate if you can help me on this. I attached the file.

thanks for your reply. I don't want to assign any employees who are off or in vacation to any shifts based on the tblVoidDate.

How can I add multiple conditions in docmd.runsql. I think since the current code is not updating tblshiftdetail based on tblvoidDate, multiple conditions are required within the docmd.runsql. I have tried to figure it out by searching the net but couldn't. any help??

Many thanks for your reply. But I don't know where to insert the code so would you please help me incorporate your code into the existing one? I am just a beginner in access. I will appreciate if you can help me.

hello, I hope you can help me on this. I am working on a shift scheduling. the problem I am facing is that I want to be able to change the number of employees per shift in table rather than modifying it in the code. this table (or query) of the number of employees per shift which I...

Hello, I'm new to the world of access and I hope that I find some help from you. the idea of what I'm trying to do is very simple and I believe it's doable in access but the problem is I don't know how. the following illustrates what I'm aiming at: 1. I want to store projects with each one of...