random selection

[David]

Hi all

I'm fairly new to queries and wondered if is possible to generate a random
selection of address.

I have an Access 2003 DB with 60,000 addresses and need to randomly select a
few hundred to write to with a good spread across the range

Can anyone suggest a way to do this.

Many thanks David (UK)

 

[Stefan Hoffmann]

hi David,

I'm fairly new to queries and wondered if is possible to generate a random
selection of address.

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

mfG
--> stefan <--

 

[David]

Thank you Stefan for the fast repsonse.Cheers, David