[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