Hi!

MS Access does not have function identical to NewID().

If you have AutoNumber in your table, and know min and max values of autonumber field, you can use RND() function for this, but you would require to run query few times for case it returns no record (if you have "gaps" in sequence of autonumber field values).

BTW, if you can use SQL Server from inside of MS Access, you can easy write SP that will query MS Access data in the same manner :-)

HTH.

>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.