Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Random select

Author  Topic 

softengilker
Starting Member

2 Posts

Posted - 2005-05-17 : 05:16:10
Hi everybody;
How can I select any number of rows randomly from a table in ms access? Can you give me please a query sample about it?

They were successful. Because They did not know achieving the task had been impossible.

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-05-18 : 12:49:14
Check this out

http://www.techonthenet.com/access/functions/numeric/rnd.htm

Jim
Users <> Logic
Go to Top of Page
   

- Advertisement -