Randomly Assigning Records

[Huxxxy]

Hi All,

Got something I want to do but not sure if it is possible I have searched through the forum and have not found exactly what I wanted hense this post..

Simplified I have 2 tables.

tbl_Employees
EmployeeID - Auto
First_Name - Text
Last_Name - Text
Department - Lookup to tbl_departments
Audit_Due_Date - Date & Time

tbl_Auditors
AuditorsID - Auto
First_Name - Text
Last_Name - Text
Department - Lookup to tbl_departments

What I want is a list generated of employees with an audit due in a by month which I have done...
Is there a way of generating a list that randomly assigns Auditors to the Employees that month, but I do not want employees that work on the same department to be assigned to that specific auditor.
I want to run this process every month to assign work to the auditors.

Thanks in advance.