Query and Report with nested top 5


G

Guest

Greetings, thank you in advance for looking at my question. Basically I am
trying to come up with an easy way to automate a report that will list the
top 5 records for one filtered field and then benieth that list the top 5
records for the next filtered field. I am a visual person so I apologize if
that isn't clear...

The table contains information on Suppliers, The Organization that made a
purchase, and then how much they spent. It is a many to many
relationship...Suppliers can have spend with many Orgs and Orgs can have
spend with many suppliers.

[Supplier]
[Org]
[Amt]

I would like to have a report that would display data based on the top five
orgs (by spend) for each supplier. It would roughly look like this...

Supplier 1
Top Org
Second Org
Third Org
Fourth Org
Fifth Org

Supplier 2
Top Org
Second Org
Third Org
Fourth Org
Fifth Org

I can't seem to find an example to work off of, so any help/guidance that
can be offered would be GREATLY appreciated. If you know of any tutorials
that would walk me through this, that would be ideal. Thank you in advance
for your assistance. I run Office 2003 and 2007.
 
Ad

Advertisements

G

Guest

I found a solution...microsoft downloads has a report sample file you can
get, there is an example in there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top