Random Select

[SharonK]

I need to randomly select x number of records from a table. I'm not
interested in writing a VBA module - isn't there some simple function or sql
statement that works???

 

[Stefan Hoffmann]

I need to randomly select x number of records from a table. I'm not
interested in writing a VBA module - isn't there some simple function or sql
statement that works???

SELECT TOP x *
FROM yourTable
ORDER BY Rnd(numberField)


mfG
--> stefan <--

 

[Howard Burgman]

I need to randomly select x number of records from a table. I'm not
interested in writing a VBA module - isn't there some simple function or
sql
statement that works???