how to select a random item from a field

  • Thread starter Thread starter JohnL
  • Start date Start date
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,
 
Try this --
SELECT TOP 1 [YourTable].*
FROM YourTable
ORDER BY Rnd(Asc([YourTable].[SomeField]));
 
Back
Top