HI,

I have two tables WORK and EMP.
Table work has fields - CaseNo,Date_Act , Handler.
Table Emp has one field - EmpName.

My field handler should be populated automatically from my table EMP.

Let us assume there are 100 records in work and 11 records in emp,
I need a query / Macro so that 100 Cases is distributed equally among 11 emp.
The challenge here is that my count of records...