Query to Randomly Select X entries based on group

[ellejay123]

I have a table with employee names and order numbers they are responsible for. I want to be able to randomly select 2 orders for each employee.

For example I have a list of 10 orders assigned to 4 employees:

Employee | Order #
Adam | 1
Adam | 2
Adam | 3
Betty | 4
Betty | 5
Betty | 6
Betty | 7
Carl | 8
Carl | 9
Dave | 10


And I want to return something like the following results:
Employee | Order #
Adam | 1
Adam | 3
Betty | 4
Betty | 5
Carl | 8
Carl | 9
Dave | 10

Everything I've found so far has been just returning 5 random entries, or 10 random entries. But I haven't found anything that allows for the grouping on another field such as Employee.

 

[CJ_London]

base what you have found on a filtered recordset

 

[ellejay123]

Thanks CJ - Would you be able to elaborate on that a bit more?

 

[CJ_London]

without knowing what you have found, not really possible.

Best I can suggest is you would use vba to take the id of the employee and use your random function based on a query which filters the table based on the id