Update Query for only a certain number of records

  • Thread starter Thread starter patientgrow
  • Start date Start date
P

patientgrow

I have a table that I am trying to assign employee names to certain number of
records. I understand how to use an update query. But I can't figure out
how to do this.

This is what I'm trying to do. I have a table with 20 "Atlanta" records. I
want to assign anything with a criteria of "Atlanta" to "Bob Smith" but I
only want to assign 10 of those "Atlanta" records to "Bob Smith" and then I
would like to assign 5 of those "Atlanta" records to "Tom Jones" and finally
I would like to assign the last 5 of the records with "Atlanta" to "Mary
Thomas".

Any ideas on how to write a query to say "assign this number of records to
this person"?

Thanks
 
You can't do this with an update query unless you have some to identify which
10, which 5, and which other 5 records.
 

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

Similar Threads


Back
Top