select - Access 2010 return first 3 occurances of results -

i creating select query compares 2 tables fine. appear on second table many times on , want return first 3 per contract. below have far.

select gcrmaster.contract_number, [20161107_emma].ccat, [20161107_emma].vertrag gcrmaster, 20161107_emma ((([20161107_emma].vertrag) in (select top 3 [20161107_emma].vertrag                                [20161107_emma] dupe                                  gcrmaster.contract_number = dupe.vertrag            order gcrmaster.contract_number desc, [20161107_emma].ccat))) order gcrmaster.contract_number, [20161107_emma].ccat;