Dear Access Gurus:



I have new requirements to distribute work request among processors evenly.

I have two tables:
Tbl_Request with fields: Req_ID, Order_Number, Proc_ID
tbl_Processor with fields: Proc_ID, Name

Tbl_Processor is static table. Tbl_Request is dynamically generated with Req_ID and Order_Number data and can be any number of records depending upon incoming request.

My goal is to assign these incoming requests to each processor evenly. Let say, I have 10 processors, but I have only 7 request comes in, then I need to assign these 7 records to the first 7th processors. Next request come let say, another 5 records, then I need to assign the first 3 records to the remaining processors, then the next 2 records to processor number 1 and so on...

I hope I am brief and clear enough with this request.

Any help and suggestion is greatly appreaciated!

Thanks

Arfaha