update certain records

P

Pietro

Hi,
Is there a way to run update table to update a certain number of records
(determined by the user in an unbound txtbox on a form)?
 
J

John W. Vinson

Hi,
Is there a way to run update table to update a certain number of records
(determined by the user in an unbound txtbox on a form)?

Possibly, but the question is ambiguous. If you have 1000 records in the table
and the user says to update 10 of them, WHICH 10 do you want to update? What
exactly are you trying to accomplish? What's the data in the table, and what's
the nature of the update?

John W. Vinson [MVP]
 
P

Pietro

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
 
J

John W. Vinson

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top