Random Schedule for Access 2007

[orange]

Ok, so you have something working that meets your needs. Great!

Regarding the Holiday and the scheduling conflict:

If the assignment/shift date is a holiday then
replace the assignment with the word "Holiday"

[DJ Rhino]

How do I do that? I have a table that we will list the holidays that we get. I need it to auto assign the dates and or holiday.How do I go about doing that?

[orange]

How did you get this

Auditor 1 Shift 1 - 2-23-2015
 Auditor 2 Shift 1 - 2-24-2015
 Auditor 3 Shift 1 - 2-25-2015
 Auditor 4 Shift 1 - 2-26-2015
 Auditor 5 Shift 1 - 2-27-2015

Whatever you called the Datefield, you have to Check whether or not it is your Holiday table.
If it is NOT in your Holiday table ---all is well
If it is in your Holiday table -- you have to change the date to "Holiday".

If you have a query such as

Select AuditorDate ...other fields....... from someTable
where AuditorDate Not IN
(Select HolidayDate from HolidayTable)

you should not get a conflict -since only nonHolidays dates would be available.

[DJ Rhino]

Here is the code I used and it works fine, but it gives me the same date for each record. I need it to advance 1 day for each auditor. Just level 1 auditors as level 2 and 3 are done by week and I have those done right.

Expr1: DateAdd("d",1,"02-Mar-15")

Would I add a field to this expresion like ID????

Also will I have to go and change that date in the code every week to get it to advance the following week?