Top 20 for each person

[asp_learner]

Hi,

I am trying to make a query Select Top 10 for each person. I can do a select Top 10 but not for each person. I think the only way is to do it in vba code. Which is to run a report for the top 10 for the first person and then run the top 10 for the next person.

Can I otherwise do it in SQL.

Thanks,
Eva

 

[David R]

Q153747 - ACC How to Create a Top N Values per Group Query

 

[asp_learner]

I found it. Thanks.

Eva