Grouping and Top 50 Records

[edojan]

Hi guys here is the query, i use access 97. It groups just fine but i need to select to 50 records for each of the "[1].CLM00_ABS_PMG_ID" and top 50 based on "[1].CountOfCLM00_CLAIM_ID1" below is the query. It groups just fine everything is good just need top 50. Now just want top 50 records because regular top 50 will just give us 50 regardless of the PMG_ID.

SELECT [1].CLM00_ABS_PMG_ID, [1].CLM00_TAX_ID, [1].CLM00_TAX_ID_SUFFIX, [1].CountOfCLM00_CLAIM_ID1
FROM 1
GROUP BY [1].CLM00_ABS_PMG_ID, [1].CLM00_TAX_ID, [1].CLM00_TAX_ID_SUFFIX, [1].CountOfCLM00_CLAIM_ID1
ORDER BY [1].CLM00_ABS_PMG_ID, [1].CountOfCLM00_CLAIM_ID1 DESC;


Thanks!