Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. randi63

    Using 'TOP n' to get multiple queries

    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
  2. randi63

    Using 'TOP n' to get multiple queries

    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...

Part and Inventory Search

Back
Top