Update Query for only a certain number of records


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
 
Ad

Advertisements

D

Duane Hookom

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


Top