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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to select a random item from a field 1
Random Function for Selecting Records 3
Real 10 random records 7
Returning a random selection 2
Random Assignment 2
Random operator 2
How do I automatically select a database record randomly? 1
Random Selection of Records 5

Back
Top