how to select a random item from a field

[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,

 

[KARL DEWEY]

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