Each row contains a case about a customer,so i want to assign certain cases
to my agents to work upon,according to the receiving date,example I want to
assign 7 cases to peter and 14 cases to John,so i want to update the field
"Assigned to" to be John or Peter...ecc
Then run an Update query with criteria (which you have not specified),
updating the Assigned To field to the value that you want it to have.
A more specific description of your table structure will make it possible to
give a more specific answer. Do you have an Employees table with a unique
EmployeeID, or will you just decline to hire a second employee named John? Can
a given case be assigned to more than one employee? What does "according to
the receiving date" mean in the context of deciding which case is assigned to
whom?
John W. Vinson [MVP]