[AccessD] Random ina query

Rocky Smolin rockysmolin at bchacc.com
Fri May 15 10:36:27 CDT 2009


Thanks Gustav. I'll forward to the client.

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, May 15, 2009 8:06 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Random ina query

Hi Rocky

No, an external function is needed:

  http://databaseadvisors.com/pipermail/accessd/2005-March/032503.html 

/gustav


>>> rockysmolin at bchacc.com 15-05-2009 16:22:44 >>>
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




More information about the AccessD mailing list