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.
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.