Top 5 list

[StephenD]

Hi,

Can you customise the 'top 5' etc. function on queries??
I'd like top have the top 5 shown and then everything else grouped as a total under 'Other'. Does this make sense???

Thanks,

StephenD

 

[BLeslie88]

Yes, I guess.... You could create a query that would have the TOP 5.... And create another Query excluding records that were equal between your Top query results and the table.... Group by in this query all which should exclude your top 5....

Does this help..?

 

[StephenD]

Thanks for the reply!

It kind of helps-do you know how I would do this automatically-Is there a function that I kind use that selects the top 5, so then I could use an If statement or somethind to select those not in the top 5?

Thanks,

StephenD