Select X # of records for each Name in the column

[Sheryl Scanlon]

I have a table with a name column in it (among others).
There are multiple records for each name and they all have
different numbers of records.

I need to pull a random sample of 10 records for each name
in the table and put them into a spreadsheet. How do I go
about this query/queries to accomplish this?

When I tried to do it, I could come up with a random
sampling of the whole table, but I couldn't divide it up
to give me 10 of each name.

Thanks for any help you can provide.

 

[Sheryl Scanlon]

Mistake posting... Sorry... meant for access.queries group.