Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

I need to know how to sort by quantity in Access.?

I am running an access query based on products and sales. How can I parce out so my query only retrieves the top 100 selling products? I know I run the entire query and run a pivot table in excel, but would like to automate this in access to limit the amount of steps.

1 Answer

Relevance
  • puaka
    Lv 5
    9 years ago
    Favorite Answer

    Try looking at various SQL examples on-line. On the other hand, using pivottables is lots more powerful and flexible.

Still have questions? Get your answers by asking now.