random selection of data....

  • Thread starter Thread starter Craigs Hotmail
  • Start date Start date
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random Selection 1
Random Sampling 2
Random Selection in Access 5
Random Sample 1
how can I select a random record for a report? 1
Random 5
Random Records selection 3
Selecting Random Records From an Excel Sreadsheet 3

Back
Top