Hi everybody,

I learnt a new trick, if you want to select random record from SQL Server, you can use

select top 1 myFieldList from myTable order by NewID()

I'm wondering, what would be Access analogue?

I've ran a search on google, but came with nothing...

What is the way to get random record in Access database? Or in Oracle?

Thanks in advance.