Results 1 to 2 of 2

Thread: Find the top 10

  1. #1
    Join Date
    Apr 2002
    Posts
    168

    Unanswered: Find the top 10

    I have a table that has many products (around 15) with its sales for each store (around 100).

    For example :


    Product Store Sales
    A 1 $10
    B 2 $30
    etc

    What I like to know is the top 10 stores (sales) for each product. I am aware I can sort by Product and Sales. However, there are still 90 stores displayed for each product. Another way to separate each product to a query, sort it and select top 10 and append each product back together. However, this way is not effective, especially I have so many products. Does anyone know how to solve this without using VBA code at all (just query) ?



    Thanks

  2. #2
    Join Date
    Jul 2001
    Location
    Estonia
    Posts
    33

    Re: Find the top 10

    Use the query "top" property to returm N top results.
    HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •