How to get a summary of just a subset
See if you all can help me sort this out :)
I have a table with this field: ID,DATE,SCORE1,SCORE2...,TOTALSCORE,AVGSCORE.
Now on the same day we have many rounds and every rounds gets its record line.
I need a report on which we have the Totals and AVG of the first 5 rounds, the best 5 rounds, and the last 5 rounds.
Any idea on how to accomplish this?
Thanks for the help