Please help me in equal distribution of a list among people

[Zeeshan7]

Hi,

I want to distribute a list (equally) between employees:-

I have two tables in MS Access:

1- Employee table: Fields are; Emp_No, Emp_Name and Billing_Date i.e. 15 (for all employees)

2- Accounts Table: Fields are; Account_No, Customer_Name, Billing_Date i.e. 15 (for all records) and Balance

Employee table contains e.g. 3 employees and Account Table contains e.g. 9 records. Now I want to distribute all 9 accounts of Accounts Table equally between 3 employees of Employee table.

Please help. Regards

[PEB]

You need to create a SELECT QUERY that choosse the top 3 values from your table with Accounts where the Field of your emplyee id is empty

Than an Update query that updates the id of your emplyee to those 3 accounts.

Run this update query 3 times for each emplyee id once without changing the select query coz it always shows the values that don't have emplyee ID

:)