[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