By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,650 Members | 812 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,650 IT Pros & Developers. It's quick & easy.

Please help me in equal distribution of a list among people

P: 44

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
Oct 19 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418
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

Oct 27 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.