Select Random Sample in Access? 1

[timbo6mel]

I understand there is not a function to select a random sample from an Access table, but is there an alternative means of doing this? I've updated a "Random" column with a random number generator, so each record is now assigned a random number. I can order the table by this column, but how do I then pull only the first, say, 6 records for my sample?

 

[PHV]

Have a look at the TOP predicate:
SELECT TOP 6 ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[timbo6mel]

That worked beautifully! Thanks much for the assistance!!!!

mel