Random Record Generation 1

[ljwmis]

I have an Access db of 70,000 + records.

I need to randomly identify approximately 1,200 records for a postal survey (require name, address fields, etc.).

I have found random number generators on internet, however they only produce a list of numbers.

How can I:

a) use these randomly generated numbers to form part of a query to generate random records (using autonumber) and format these records for a possible mail merge?

or

b) forget the internet random numbers and write a query within the db to generate random records for output and a possible mail merge?

Thanx for any help.

 

[JoeMiller]

The Access Web has a function to do this, try this web link:

http://www.mvps.org/access/queries/qry0011.htm

HTH Joe Miller
joe.miller@flotech.net