[AccessD] Random numbers lottery-style

Yes.  If you find it exits just cycle back through the process again.

Would only work for this one process of course - wouldn't be reusable in
other apps without adaptation.

Perry

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Erbach
Sent: Thursday, March 03, 2005 2:59 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Random numbers lottery-style


Perry,

Are you talking about examining the recordset every time a new ActivityID is
randomly selected for the current Volunteer before a new row is added? That
should work. I guess I'm looking for something a bit more general purpose;
that is, a function that returns a number from a given list while removing
the number from the list for the next go round.

Thanks,

Steve Erbach

On Thu, 3 Mar 2005 14:29:53 -0500, Perry Harold <pharold at proftesting.com>
wrote:
> Steve
> 
> How adding a check to see if the ActivityID is already in the selected 
> list
> - then cycle around and run the randomizer again until there's not a
match?
> 
> Perry Harold
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com