random selection of data....

C

Craigs Hotmail

Hello All
hope someone can help...I have a table of 4000 records...there are 50
different users that have entered this data...need to randomly select 2
cases per user...
I am using the latest version of Access...any thoughts how this can be
achieved?

Thanks
Craig
 
M

Micah Chaney

Just a thought/idea -- you might try creating some algorithm based off two
numeric fields (ie multiplying the two fields together) sort by that field,
then do a GroupBy and user (Input person) and then do a Top Values filter --
I think you can do the top two Values, not sure...anyway that should yield
100 results. HTH...
 
Top