Calculate Top 12 from each group and rank the group

dhascup · #1 (**permalink**) 08-07-12, 12:09

My results database has about 10,000 records.
Each "GROUP" could have anywhere from 8 to 30 records.
I need to grab the top 12 records from each GROUP, grab the total of the top 12 records and then rank the group by that total

Example database

Quote:

BOB 10
BOB 11
BOB 14
BOB 16
BOB 13
BOB 18
SAM 15
SAM 12
SAM 17
SAM 11
SAM 10
SAM 13
JOE 15
JOE 12
JOE 17
JOE 11
JOE 10
JOE 13
BILL 10
BILL 11
BILL 11
BILL 16
BILL 12
BILL 14
MIKE 11
MIKE 12
MIKE 10
MIKE 19
MIKE 11
MIKE 11

So the overall rankings would be

Quote:

Bob = 82
Sam = 78
Joe = 78
Bill = 78
Mike = 78

For example, I will just assume we want the top 3 points
I need the REVISED RANKINGS to show

Quote:

Bob = 34
Sam = 32
Joe = 32
Mike = 31
Bill = 30

Can someone point me in the correct direction to do this?

Regards,
David