Jury Selection

I take it that you have individual records for each potential juror. each juror should have a field that can be flaged if the spcific juror has been selected before. Once a juror is selected you flag them as being so. then you set up your random routine that if a person is randomly selected that has been flaged as previously selected they are ignored and another person is selected in thier place. thus you never select a person twice.

hope a helped ya

I think you are right on using Access as you can incorporate the random number generator utilized by Visual Basic.

I think it's important, however, to remove previously selected jurors once they have been selected as a pool of 100. This can be done by a simple Delete or Make Table Query.

Using access to select your current population, and then moving/deleting them sounds like a good idea.
But, if your planning on setting these names up for using in a mailing list, then I'd recommend looking at mass mailing products like Mailmgr 2010 (www.bccsoftware.com) which do these tasks very well, and you'll have your mailing list Cass certified, presorted, and ready for the post office.

I'm not a big access user, but, I've hit upon a method which works for a similar task. In your database, you will have a field for each person's record which is "Served". If they were selected, you make it whatever you want it to be, a Y or 1, or yes, etc...but be consistant.
Then, you run a query like
If juror_served <> "Y" then copy juror to Temp_juror Table. Then make your random selector use the temp_juror table for what it queries, and then at the end (after selecting 100 jurors) makrs in the original table in the "Served" field the appropriate number/letter. As for how to do the randoming, I have no idea.