Search results

I have created calendar table with all US holidays and weekends as none working days to use for scheduling. Attached are the tables that I created and the relationships. I would like RANDOMLY schedule 22 workers for two shift daily Monday-Friday on a monthly bases. I need help creating query...

Hi arnelgp. Thanks for quick respond. I have found a script to create a calendar for SQL server. I would like to use it in access. Do I need to make any changes in the script? How do I use the script in access?

How do I use (In module or VBA code for a command) the SQL Server Script in MS Access and does it require any changes in the script to make it work in access?

Thank you. Let me work on it.

Thank MickJav, I got now lot of info to look up.

I haven't started yet, I want to know how to separate the info that I have through out the tables so then I can establish the relationship between tables and work out the detailed

I would like to create a database to schedule 20 workers for two shift daily Monday-Friday on a monthly bases and output to the calendar, considering US holidays as none working days, which should be an option to enter in the database. Also some of the workers are not working on Mondays and some...

Thank you, I will

Thank you DBGuy, I would like to create a database to schedule 20 workers for two shift daily Monday-Friday on a monthly bases and output to the calendar, considering US holidays as none working days, which should be an option to enter in the database. Also some of the workers are not working...

Hi All, My name is Masis and I am a beginner in MS Access. Crystal refer me to this forum. Many thanks to her for her help and referral.