[AccessD] Need names

If you have 10000 names already, assuming first name and last name fields, 
set up a loop that concatenates first name of current record plus move n for 
last name, then move back n-1 and increment n in the loop until it reaches 
EOF.  Start the next loop from record n + 1.  This will generate 9999 + 9998 
+ 9997 ... name records without even getting into middle names or initials.  
You can then let the dupes wizard find the dupes and nuke them.  If you let 
n go from 1 to about 105, you'll have near enough a million names.  Let it 
go the full 10000 and you get 50,000,000 before culling duplicates.

Whenever I create a demo database that requires a significant number of 
Employee or Contact records, I take a few thousand real names and mix and 
match them up in this manner.  If phone numbers are required, a random 
number works OK but I often use something like an address ordered company 
table list of fax numbers so as to get real area codes and sensible numbers.

Hen




>From: "John W. Colby" <jcolby at colbyconsulting.com>
>Reply-To: accessd at databaseadvisors.com
>To: "AccessD" <AccessD at databaseadvisors.com>
>Subject: [AccessD] Need names
>Date: Fri, 21 Feb 2003 19:50:38 -0500
>
>Can anyone send me a db with just the first name / last name of a BUNCH of
>people (hundreds of thousands)?  I have built a hash algorithm that returns
>no duplicate values for 10,000+ names (assuming no duplicate names).  I
>would like to test it for hundreds of thousands of names.  I will worry
>about getting rid of dupe names.
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com


_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail