want to retrieve a random sigle record from a table with a query

[wrenchman123.ca]

how might I go about this

 

[Steve Schapel]

Wrenchman,

Try this...
SELECT * FROM YourTable
WHERE YourID In(SELECT First([YourID]) FROM YourTable)