Randomizing Selections

  • Thread starter Thread starter Kevin Jessop
  • Start date Start date
K

Kevin Jessop

I have a database of 780,000 records. I am trying to get
Access to pull a random 10,000 records from this database
and then export that 10,000 into Excel.

I am having no success at all in the random selections -
I would like to export the whole database into Excel and
do it that way - but the dataset is too large.

Does anybody have any suggestions?

Kevin
 
Try something along the lines of
SELECT TOP 10000 FROM
(SELECT * , Rnd() FROM YourTable ORDER BY Rnd())

Hope This Helps
Gerald Stanley MCSD
 
Back
Top