 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008update certain records
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)? >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] 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 > >Hi, > > Is there a way to run update table to update a certain number of records [quoted text clipped - 6 lines] > > John W. Vinson [MVP] >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] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.