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

  • Thread starter Thread starter Guest
  • Start date Start date
Wrenchman,

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