how to select a random item from a field

J

JohnL

I am building a simple database to randomly select items from a table, but
can't seem to build a query that will randomly select one record from the
table.

Thanks,
 
K

KARL DEWEY

Try this --
SELECT TOP 1 [YourTable].*
FROM YourTable
ORDER BY Rnd(Asc([YourTable].[SomeField]));
 
Top