Dividing a File

  • Thread starter Thread starter Bunky
  • Start date Start date
B

Bunky

I am going to have a file with 55,000 records on it that I want to split up
among 10 people so each has 5,500 records to work individually. I will need
to assign two pieces of information that will be unique to each person
(UserID) and Phone.
Ideas?
 
If the records always have a telephone number, I would just grab the last
digit of the phone number and use that to assign the records.

Joe gets all phones ending in zero
Ann gets all phones ending in 1
Bob gets all phones ending in 2

That might not be totally accurate but it should give you a pretty good
approximation of equal division.

Or if USERID is numeric or can be forced to numeric then use
UserID Mod 10
and assign the results 0 to 9 to your individuals.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Have an Autonumber field and create a calculated field in your query --
Assignment: ([AutonumberField] Mod 10) +1

Sort on Assignment and then any other fields needed.
 
Thank you, Karl! It works like a champ!

KARL DEWEY said:
Have an Autonumber field and create a calculated field in your query --
Assignment: ([AutonumberField] Mod 10) +1

Sort on Assignment and then any other fields needed.

--
Build a little, test a little.


Bunky said:
I am going to have a file with 55,000 records on it that I want to split up
among 10 people so each has 5,500 records to work individually. I will need
to assign two pieces of information that will be unique to each person
(UserID) and Phone.
Ideas?
Click to expand...
Click to expand...
 
Back
Top