Require Random % of records selection

zonexs123

Registered User.
Local time
Today, 16:33
Joined
Feb 6, 2011
Messages
39
Hi,

I have a table called "Data" with following fields:
1) CompDate
2) LOB
3) Task
4) User

Need a query or VBA to bring random records with certain % (ie. 20% or 30%) of each User withTask wise
For example:
User "Abhinav Verma" has done in total 17 "Binders". Need to show only 30% of "Binders" records (5 records). Similarly with other task as well.

Thank you in advance.
 

Attachments

Users who are viewing this thread

Back
Top Bottom