Thanks Alexcuse for your reply. I had problems understanding your proposed solution so I must try and find a different way to describe the problem. Please forgive me for wasting your time.
randi63
The more I learn, the less I understand
I am using Access 2003. I wish to extract the 'TOP n' records for each of about 100 separate items from field item_list without running 100 separate queries. From extensive reading I surmise that I should use a sub-query, but nothing I try seems to work. In each row I want to extract the full...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.