Top 5 Most Often

[paluccie]

Hi All,

I have a table that is titled Customers, in that table there is a field for Firms.
I want to run a query that will show the top 5 firms that do the most business. Everything I try gives me the top 5 records which I don't want. Any help would be great. Thanks

 

[Matty]

Could you sort your firms by the amount of business they do and then take the top 5?