how do i limit the records in a number of groups in access

[JB Optimisation]

We have products grouped into categories. I wish to select the top 10 from
each category by Sock on hand. Is this possible?

 

[Allen Browne]

See:
http://allenbrowne.com/subquery-01.html#TopN