[AccessD] Random ina query

Cool.  Thanks.

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Friday, May 15, 2009 8:08 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Random ina query


  Yup.  Define a column as Rnd(1), sort on that column and set the TOP
predicate for the query for the number of records you want.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, May 15, 2009 10:23 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Random ina query

Dear List:

 

Can you use the random function in a query so that the query picks a certain
number of unique records at random from a table?

MTIA

 

Rocky

 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com