Automatic assigning

[Eltoque]

Hello,
I have a question that may be well beyond my abilities with Access, but it never hurts to ask. Here is what I am doing:

I would like to have a list be automaticly and randomly distributed among a group ( ie placing the items in their respective initials). The individuals would be responsible for those items for that day. The next day, the items will agian be re-shuffled and randomly assigned again. Further-more, I would like to set a check box or something that they could click that would allow them to keep an item so it will not be redistributed.

I am working in Access 2002.
Any thoughts?

 

[jfgambit]

Here is an example of how to generate a random record list via a query:

Select Top 5 EmpNbr, Rnd(EmpNbr) from YourTable order by rnd(EmpNbr)

To not include the "checked" ones:
Select Top 5 SecSecNo, Rnd(SocSecNo) from YourTable order by rnd(SocSecNo) where CheckBox <> 1

HTH


&quot;I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?&quot;