General discussion

Locked

Jury Selection

By iversn ·
I am developing a jury selection program in Access 2000. I am having problems with the random selection feature. I have 1000 people and I want to randomly select 100 people today then in 2 weeks I may want to select another 100 from the remaining900. Any suggestions on how to do this? Or should I be using Excel?

This conversation is currently closed to new comments.

11 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Jury Selection

by Lo In reply to Jury Selection

Hi - This is a very general answer and only a pointer to a soltuion. VB has a Random Number generator (I used it when playing with a Craps Program to simulate dice rolls). Look in HELP, random-number, there are 3 entries there, Rnd Function is theactual call. Lo

Collapse -

Jury Selection

by iversn In reply to Jury Selection

The question was auto-closed by TechRepublic

Collapse -

Jury Selection

by shadowtraitor In reply to 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

Collapse -

Jury Selection

by iversn In reply to Jury Selection

The question was auto-closed by TechRepublic

Collapse -

Jury Selection

by deannar In reply to Jury Selection

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.

Collapse -

Jury Selection

by iversn In reply to Jury Selection

The question was auto-closed by TechRepublic

Collapse -

Jury Selection

by White Wolf In reply to Jury Selection

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.

Collapse -

Jury Selection

by iversn In reply to Jury Selection

The question was auto-closed by TechRepublic

Collapse -

Jury Selection

by shepherr In reply to Jury Selection

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.

Collapse -

Jury Selection

by iversn In reply to Jury Selection

The question was auto-closed by TechRepublic

Back to Community Forum
11 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums