Making a "Top 50" list 1

[sirace]

I have a database with over 90000 records. It contains many fields, but the pertinent ones for my query are as follows:

rep_no, account_no, value, address_1, address_2, revenue, ACH

I need two reports from this data. One report will use the data as is. The other report needs to show the top 50 revenue creating accounts grouped by rep_no. I'm not sure how I can show the top 50. Not all reps have 50 accounts and of course, many have much more than 50. Suggestions are appreciated.

 

[SteveR77]

This should be what you were looking for -

http://support.microsoft.com/?kbid=296449

I hope it helps you.


Steve

 

[sirace]

Thanks, that's exactly what I was looking for!