How can I display 20 random records per OperatorID

[Liz_I3]

Hi
I am working in Access 2010
I want to create a query that will extract 20 random records from a table per OperatorID.
I am using the rnd function with the Abs and have set the number of records returned in the query properties to 20. But all I am getting is 20 random records not 20 per operatorID. I did not want to group the records just display 20 rows per operator that had data that day. What am I missing

Thanks
L

 

[Micron]

Methinks you will have to create a query that gets a recordset of operators that meet your criteria, then base the aggregate query you have on that. Equal join between OperatorID in first query to OperatorID in second should do it.

 

[Liz_I3]

I am still only able to get the 20 records. I need to get 20 difference records for each operator ID. There are approx. 11 operators at present but this could vary.

Any Ideas are appreciated
Thanks
L

 

[Micron]

You will have to provide some clues - we know nothing of your table/field inputs or what you have for a query so far. I suggest you create some fake data in Excel, complete with table name in A1, then field names as colum headers in row 2, then data. Keep the column sizes small as possible. You can create a range for each table as required, then copy and dump into your next post. Include your sql as well.