Random Records Pull in Query

[akrshaw]

I have read the random records posts using rnd() and the Top 10 sql.

But none of these seem to be returning what I am looking for.

I have a HUGE table...I want to return 26 random records in that table.

The only two fields are ID and Word.

When I use either solution above all I get are the first 26 records in the table?

Thanks!~

 

[genomon]

PLease show us the SQL.

Ni neart go cur le cheile.

 

[MajP]

Works fine for me.
SELECT TOP 26 Products.ProductID, Products.ProductName, Rnd([productID]) AS SortOrder
FROM Products
ORDER BY Rnd([productID]);

You have to seed the RND with a different value for each record.