top 5 results in a report

F

Fipp

I am working on a database that is full of data from a football game. Each
play is a record with many fields. I am trying to get a report to return the
top 5 run plays in each formationgroup based of the frequency of that play
occouring.

for the sake of this question I will say that I have the following fields:

'rp' this field indicates weather the play is a run or a pass
'play' - This field is the name of the run play or the name of the pass play
'formation' - This field indicates the formation.

I appreciate your help.
 
Top