Make Employees Rotate By Week?

[Dave Elliott]

How can I make my list of employees rotate by week for there week of call?
I have my employees table with the fields ;
On Call Text which list the employee
Call Yes/No which when checked shows whether the employee is
on the call list
Order Number which shows the order in which they are supposed to
be on call.

I also use two unbound fields for the date criteria for the work week.
this is used for the query that is supposed to show the current employee on
call.
My form I use for this is named frmEmployeeOnCallList
sql is below for the form.

SELECT [Forms]![frmautopayrollreport]![StartDate] And
[forms]![frmautopayrollreport]![EndDat] AS Criteria, Employees.Order, [First
Name] & " " & [Last Name] AS [Employee Name], Employees.[On Call],
Employees.Call, Employees.Selected FROM Employees WHERE
(((Employees.Call)=Yes) AND ((Employees.Selected)=Yes)) ORDER BY
Employees.Order, Employees.[On Call];

field 1 BeginDate =CDate([AnyDate])-(Weekday(CDate([AnyDate])))-2
fields 2 EndDate =CDate([AnyDate])-(Weekday(CDate([AnyDate])))+4
field 3 AnyDate =Date()
these fields are located on main form which always stays open.
it is named frmAutoPayrollReport

Any Help or direction would be appreciated,

Thanks,

Dave