Divide a table of records into three random equal lists.

[Guest]

I have table with 2000 records. I need to divide it up into three separate
equal lists.
I have three end users that will be working on a third of this table each.
I am currently... manually taking the total number of records dividing that
number by three and creating three separate queries to pull only those 'one
third' records.

i.e.
1 - 666
667 - 1333
1334 - 2000

Is there any easier way?

 

[Guest]

Not sure how you are doing your queries but consider this method.

Add an assigned field to the table.
Create an update query to update the assigned field. In design view click
on the icon that reads "All" and change it to 666. Run the query to update
with the first assigned.
Next add criteria to assigned field Is Null.
Put the icon back to "All." Run the query to update with the third assigned.

 

[Guest]

Thanks for such a quick response.

That would work for the first third, but I am not sure how to get the 2nd
and 3rd set. I went ahead and tried putting 666-1333, but it doesn't like
the hyphen. I'm not sure if you can put a range in the 'top' field.

 

[Guest]

Now range needed. The criteria will allow you to pull only those that have
not been updated. Using the criteria and quanity you will be updating only
the next 666 records.